Advanced Search

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





SQL