To understand difference between
CONVERT(VARCHAR(20),CONVERT(DATETIME,ExecutionDate),101) is MMDDYYYY
and
CONVERT(VARCHAR(20),CONVERT(DATETIME,ExecutionDate),103) is DDMMYYYY
The website is: -
http://www.sql-server-helper.com/tips/date-formats.aspx
234 unique visitors
No comments:
Post a Comment