>I have this command which I execute on several servers to insert a record:
>
>
>INSERT INTO [FieldType] ([[AddUser],[AddDate],[ModUser],[ModDate],[Title])
> VALUES (1,'19/02/2010 02:05:06',1,'19/02/2010 02:05:06','Integer')
>
>
>However, on one particular server, this doesn't work. I get this message:
>
>"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
>
>Something is different on the client server in the configuration and I am trying to know what it is. Any help would be appreciated?
See also
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se for details on the problem.
If it's not broken, fix it until it is.
My Blog