TIME

TIME provides for storage of an hour-minutes-seconds-fractional-seconds value with six digits in the fractional-seconds part. Derby also supports the ISO format of 8 characters (6 digits, and 2 decimal points).

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.

Related Information

TIME'HH:MM:SS[.FFFFFF']

Examples

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