Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Unknown Unknown SQL Query date conversion problem RE: SQL Query date conversion problem
samjudson
SSC Enthusiast
Points: 139
More actions
May 29, 2013 at 11:51 pm
#1619552
Not sure why you are trying to convert a string to a string and then to a date in the second part.
But 103 is UK format, not 101. Try passing this into the datetime convert, not the varchar one.
CONVERT(datetime, '18/05/2013', 103)