Posted By

rengber on 09/03/09

Tagged

Viewed 1722 times

Favorited by 1 user(s)

/ Published in: SQL

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. :-)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--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)

Comment:

You need to login to post a comment.