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-23.59.59.999999 |