Ok...i've given up and decided to convert...
Little backstory...
Large tables with dates stored in varchar columns. I need to convert them to datetime columns. Some are stored as
1/18/00 3:58:58 PM
And some are just
01/18/00
I would like to convert the columns into datetime using cast() and convert() but keep getting the error "The conversion from char data type and datetime data type resulted in an out of range date value." and cannot get any furthur. I suppose I could write some VBscript function to chew the date apart and update the columns individually but the table is pretty big.(>100,000 records) I would like to do the conversion in sql if possible. Any ideas.
