time

The following syntax shows the formats for TIME constants.

time :
 		TIME "HH:MM[:SS[.dddd]]"

The formats following the TIME keyword conform to the SQL standard.

In the format for time constants, HH is hours (0 to 23), MM is minutes (0 to 59), SS is seconds (0 to 59), and .dddd is the fractional part of a second, with up to four decimal places of accuracy. If you specify more than four places, the value rounds to four places. The format for timestamp constants simply combines the formats for date and time constants.

set_time_format:
          SET TIME FORMAT [TO | =] "HH[:MM[:SS[:F[F[F[F]]]]]]"