apache > db
Apache DB Project
 
Font size:      

DATE, TIME, and TIMESTAMP limitations

DATE, TIME, and TIMESTAMP limitations


Table 31. DATE, TIME, and TIMESTAMP limitations

The following table contains limitations on date, time, and timestamp values in Derby.
ValueLimit
Smallest DATE value0001-01-01
Largest DATE value9999-12-31
Smallest TIME value00:00:00
Largest TIME value24:00:00
Smallest TIMESTAMP value0001-01-01-00.00.00.000000
Largest TIMESTAMP value9999-12-31-24.00.00.000000

Previous Page
Next Page
Table of Contents
Index