Bloody Date Settings!!

[natman]

We have recently switched servers and now we have some web pages failing because of invalid dates.
We have checked the regional date settings and they are all set correctly.

What else is different?
What are the differences, if any, between the way SQL 7 and SQL 2000 handle dates?

thanks in advance
Natman

 

[tlbroadbent]

This question should be asked in the SQL Server forum183.

SQL 7 and SQL 2000 handle dates the same way. What is the default language for SQL Server 2000. The definitions for each language establish how date data is interpreted. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.