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