JDBC metadata type (java.sql.Types)
TIME
Dates,
times, and timestamps cannot be mixed with one another in expressions except
with a CAST.
Any value that is recognized by the
java.sql.Time method
is permitted in a column of the corresponding SQL date/time data type.
Derby supports the following
formats for TIME:
hh:mm[:ss]
hh.mm[.ss]
hh[:mm] {AM | PM}
The first of the three formats above is the
java.sql.Time format.
Hours
may have one or two digits. Minutes and seconds, if present, must have 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.
