DATE, TIME, and TIMESTAMP limitations
The following table lists limitations on date, time, and timestamp
values in .DATE, TIME, and TIMESTAMP limitations
Value
Limit
Smallest DATE value
0001-01-01
Largest DATE value
9999-12-31
Smallest TIME value
00:00:00
Largest TIME value
24:00:00
Smallest TIMESTAMP value
0001-01-01-00.00.00.000000
Largest TIMESTAMP value
9999-12-31-23.59.59.999999