[thelist] bad sql data

Robert Vreeland vreeland at studioframework.com
Sun Nov 27 21:32:38 CST 2005

Ken wrote
I'm not sure what you mean by "out of range" dates. If the dates were not
valid, then they would never have been accepted by SQL Server in the first

To clarify, 'out of range':
If you have a date field and the server has it's date format set to US
format, then 13/09/2005 would be invalid as there is no 13th month. Same
value on a server set to European format would go through no problem. As the
sql server is grabbing this expected format from the OS, the setting can
change. The problem comes in using that data. Specifically, we have a
routine that makes a copy of a database. It starts by creating an empty
database from a script then populates it from the selected database, and
since dome of those dates are in the wrong format, it blows up.


More information about the thelist mailing list