The TIME Data Type Stores time values without date components.

Declaration


TIME

Additional Information

Use this information when declaring column types with the CREATE TABLE statement or casting values to new data_types for use in functions or output.

  • Convert values to the same type with the CAST function.

  • Allows time formats compliant with the java.sql.Time method.

  • The following three formats are explicitly supported:

    • hh:mm[:ss]

    • hh.mm[.ss]

    • hh[:mm] {AM PM}
  • Hour values can be one digit or two; provided minute and second values must be two digits.

Examples


TIME
1:23:45

TIME
12:08 PM