Font size:

DATE, TIME, and TIMESTAMP limitations

Table 31. DATE, TIME, and TIMESTAMP limitations

Value	Limit
The following table contains limitations on date, time, and timestamp values in Derby.
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-24.00.00.000000