How can we help you today? How can we help you today?

Smalldatetime problem

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
0

Comments

3 comments

Sort by
  • paulh
    Ok, just changed the tables to datetime, same thing happens - is this a config setting on my server?
    paulh
    0
  • paulh
    Ok, this is the same problem raised by cneyb - and the 'US English' idea suggested by Ben worked for me.
    paulh
    0
  • Michelle T
    Version 7.1 should have solved this problem for you.
    Michelle T
    0

Add comment

Please sign in to leave a comment.