DATE provides for storage of a year-month-day in the range supported by java.sql.Date.
Dates, times, and timestamps must not be mixed with one another in expressions.
yyyy-mm-dd mm/dd/yyyy dd.mm.yyyyThe first of the three formats above is the java.sql.Date format.
The year must always be expressed with four digits, while months and days may have either one or two digits.
Derby also accepts strings in the locale specific datetime format, using the locale of the database server. If there is an ambiguity, the built-in formats above take precedence.
VALUES DATE('1994-02-23') VALUES '1993-09-01'