while executing the following statement:
select convert(datetime,'Nov 31, 2002 10:05pm')
got the following error:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
the datetime set is mdy
is there any way to make this work though this is not according to the iso standarts.