Smalldatetime problem

paulhpaulh Posts: 35 Bronze 2
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.


Sign In or Register to comment.