DATE, TIME, and TIMESTAMP limitations
Table 1. DATE, TIME, and TIMESTAMP limitations. The following table lists limitations on date, time, and timestamp values in
Derby
.
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-24.00.00.000000
Parent topic:
Derby limitations
Related reference
Limitations on identifier length
Numeric limitations
String limitations
Limitations for database manager values