Smalldatetime problem

paulh

Anyone have problems inserting smalldatetime?

Ran a comparions and it generates a row with '2008-05-20 21:13:00.000' which causes an error on insert...

Msg 296, Level 16, State 3, Line 7
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

Smalldatetime goes up to 2079 and the date is in ISO format so this should work.

paulh

Ok, just changed the tables to datetime, same thing happens - is this a config setting on my server?

paulh

Ok, this is the same problem raised by cneyb - and the 'US English' idea suggested by Ben worked for me.

Michelle T

Version 7.1 should have solved this problem for you.