Return to Snippet

Revision: 17413
at September 3, 2009 21:48 by rengber

Initial Code
--UK/NZ format dd/mm/yyyy
select CONVERT(DATETIME, '21/03/2000', 103)

--US format mm/dd/yyyy
select CONVERT(DATETIME, '03/21/2000', 101)

Initial URL

Initial Description
I am forever forgetting this.  Have to look up the 101 vs 103 in books online every time.   
Also forget which way around is US/NZ format.  :-)

Initial Title
TSQL Convert DateTime

Initial Tags
database, sql, simple

Initial Language