I have this condition in a query:
WHERE fielddate> = '2010-10-01 'AND fielddate <= '2010-10-18'
to migrate the database to another server (2008) with the same engine database (sqlserver-2005 Express), returned error:
The conversion of a char data type to a datetime data type resulting in an out-of-range datetime value.
But if I make this query works
WHERE fielddate> = '20101001 'AND fielddate <= '20101018'
the collation type is the same:
Modern_Spanish_CI_AS
and all the other features that I saw are the same.
I do not know what the problem is
Thanks.