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. :-)
- --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)
You need to login to post a comment.