Technical Article

Script to return datetime as just date

You can return the date as a string (varchar) in whatever date format you like by adding a 'style' to the CONVERT statement. Exmaples of style values are (two left hand columns):1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 - dd […]

3.33 (3)

You rated this post out of 5. Change rating

2005-02-18 (first published: )

195 reads

Blogs

Using Cron in Postgres Flex

By

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...

Can I Change a Primary Key Value? #SQLNewBlogger

By

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

By

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Read the latest Blogs

Forums

50 Years of Microsoft

By Steve Jones - SSC Editor

Comments posted to this topic are about the item 50 Years of Microsoft

Multiple Collations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Collations

Retrieving Data Using the REST API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Retrieving Data Using the REST...

Visit the forum

Question of the Day

Multiple Collations

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...

See possible answers