Search the Community
Showing results for tags 'sql convert'.
Hi all I have a varchar column in a DB with dates. I'm trying to convert the string (example: 'Apr-10-2009') (MMM-dd-yyyy) to a datetime but gives: varchar data type to a datetime data type resulted in an out-of-range value. I realize it has to be the 3 char month but not sure what convert method I need to do this. Any suggestions?