Radhwen.Khelia Radhwen.Khelia - 22 days ago 6
SQL Question

Arithmetic overflow during SQL transaction

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

Answer

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