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
Scripting on this page tracks web page traffic, but does not change the content in any way.