Home Forums SQL Server 7,2000 Globalization The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. RE: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

  • September 25, 2012 at 3:47 pm

    #1542116

    Your database login may have a default language different than English, or the production server's default language may not not match the one to your login. Maybe the agent for the job has another default language as well. Either way default languages may not be matching. It is thus best to always use the universal yyyymmdd string format for dates.

    ----------------------------------------------------