Date format in Sql Server 2000 italian and english

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

MaurizioSELECT *
FROM table
WHERE dateofbirth ='20040115'

--
David Portas
SQL Server MVP
--|||SELECT *
FROM table
WHERE dateofbirth ='20040115'

--
David Portas
SQL Server MVP
--|||Maurizio Fazio (maurizio.fazio@.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, esquel@.sommarskog.se

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