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 |