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-
Largest TIMESTAMP value 9999-12-31-
Related reference
Limitations on identifier length
Numeric limitations
String limitations
Limitations for database manager values