Jump to content

JCBond

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by JCBond

  1. Thanks for your response. Yes, I was thinking about that all through the process of the Convert / Cast possibilities & attempts. The one test I did through my SQL Server Management Studio with local SQL Express was to recreate a temp table from the Employee table, but change the one varchar field with that date string entry to a datetime field. I then did an "Import" into the new temp table to see if it would throw an error with a misspelled 3 char month, or an invalid day-year value - there were no errors. Of course, I did check for nulls in the original varchar field... none
  2. 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?
×
×
  • Create New...