TIME data type

TIME provides for storage of a time-of-day value.

Syntax

TIME

Corresponding compile-time Java type

java.sql.Time

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.

Examples

VALUES TIME('15:09:02')
VALUES '15:09:02'