Arithmetic overflow during SQL transaction

Question

Why does inserting '0001-01-01 00:00:01' to a DATETIME field cause an error ?

It's telling me :

Arithmetic overflow during implicit conversion of VARCHAR value '0001-01-01 00:00:01' to a DATETIME field . SQLState: ZZZZZ ErrorCode: 247

Isn't this a semantic analysis of my request ?

Thanks

dazedandconfused · Accepted Answer · 2016-11-18 14:30:15Z

3

Per the Sybase online docs, the minimum value supported by the datetime type is January 1, 1753 00:00:00.000

answered Nov 18, 2016 at 13:46

dazedandconfused

3,2162 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1