# 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