JDBC metadata type (java.sql.Types)
DATE
Dates,
times, and timestamps must not be mixed with one another in expressions.
Any
value that is recognized by the
java.sql.Date method is permitted in
a column of the corresponding SQL date/time data type.
Derby supports
the following formats for DATE:
yyyy-mm-dd
mm/dd/yyyy
dd.mm.yyyy
The 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.
