You will have a problem with 09/08/2008. This could be interpreted in two ways. Sept 8 or Aug 9.
Here are some of my notes regarding dates.
Try analyzing the pattern and see if it's mm/dd/yyyy or dd/mm/yyyy. Based on your example it's mixed. Try to make it a single format first then convert the column to smalldate or datetime, depending on your requirement.For that read my old notes, here
-- CK
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