But the problem is we have dates in Varchar instead Datetime
While Converting Varchar To Datetime All four formats are unable to
Convert
ie
select Convert(Datetime,'18-11-2008 2:35:19 PM',102) -- error
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
select Convert(Datetime,'11-18-2008 2:35:19 PM',102) ok
select Convert(Datetime,'18/11/2008 2:35:19 PM',102) Error
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
select Convert(Datetime,'11/18/2008 2:35:19 PM',102) ok