You should use date format that is independent of date format setting on the server (SET DATEFORMAT)
'2010/02/19 02:05:06'
>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?
--sb--