Skip to content

Instantly share code, notes, and snippets.

@actaneon

actaneon/SQLDateConvert.txt

Created July 7, 2009 14:59
Show Gist options
  • Save actaneon/142139 to your computer and use it in GitHub Desktop.
Save actaneon/142139 to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL Date Conversions
Raw
SQLDateConvert.txt
Fmt Standard Input/Output
------------------------------------------------
100 Default mon dd yyyy hh:mi(AM/PM)
101 US mm/dd/yyyy
108 - hh:mi:ss
112 ISO yymmdd
114 - hh:mi:ss:mmm
120 ODBC Canonical yyyy-mm-dd hh:mi:ss
121 ODBC Canonical yyyy-mm-dd hh:mi:ss.mmm
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment