>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?
19/02 is British/German format. This server has different Date format.
Always use ISO dates to avoid confusion.
If it's not broken, fix it until it is.
My Blog