Radhwen.Khelia Radhwen.Khelia - 1 year ago 96
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 ?


Answer Source

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