Date format in Sql Server 2000 italian and english

[Maurizio Fazio]

I have a Sql Server 2000 installation and my server is Win2k sp2
English.
If i run a query with WHERE condition, for example,

SELECT * FROM TABLE WHERE DATEOFBIRTH ='2004-01-15'

my resultset contain the records correct.

But the results with the same query, which run on a Sql Server 2000
installation with same collation and a server Win2k Italian, is:
'La conversione del tipo di dati da char a datetime ha generato un
valore di tipo datetime non compreso
nell'intervallo di valori validi.'

English error:
'Converting data type from char to datetime has generated a datetime
value that is out of range of valid values'

It is not possible to change all query in my client application.

How I can have the same results for the same query in both
installations?

Thanks in advantage

Maurizio

[David Portas]

SELECT *
FROM table
WHERE dateofbirth ='20040115'

--
David Portas
SQL Server MVP
--

[David Portas]

SELECT *
FROM table
WHERE dateofbirth ='20040115'

--
David Portas
SQL Server MVP
--

[Erland Sommarskog]

Maurizio Fazio (ma************@gmail.com) writes:

I have a Sql Server 2000 installation and my server is Win2k sp2
English.
If i run a query with WHERE condition, for example,

SELECT * FROM TABLE WHERE DATEOFBIRTH ='2004-01-15'

my resultset contain the records correct.

But the results with the same query, which run on a Sql Server 2000
installation with same collation and a server Win2k Italian, is:
'La conversione del tipo di dati da char a datetime ha generato un
valore di tipo datetime non compreso
nell'intervallo di valori validi.'

English error:
'Converting data type from char to datetime has generated a datetime
value that is out of range of valid values'

It is not possible to change all query in my client application.

How I can have the same results for the same query in both
installations?

In addition to David's response, check out this article for the
gory details: http://www.karaszi.com/SQLServer/info_datetime.asp.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp