Datetime Formats

  • Script

This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.

4.5 (2)

2016-04-13 (first published: )

2,448 reads


My home office setup


That aging hippie (he likes Apple products and has a goatee) known as Brent...

Changing the owner of a schema removes all direct permissions of objects owned by the schema.


This is one of those things that probably doesn’t happen all that often, but...

In Memory Table Indexes


Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s...

Read the latest Blogs


What could cause MS Access app as a front-end to SQL, periodically run slow?

By Rod at work

We've got an old Microsoft Access pharmacy application which acts as a front-end to...

SQL Server Case statement conditions

By mattdarvellwow

Good afternoon, I am currently working on a data flow and have been given...

Weird CAST/TRY_CAST Behaviour

By Chris Wooding

I have a fact table with two numeric columns defined as DECIMAL(28, 12) and...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers