time_tz

The following syntax shows the formats for TIMETZ and TIMESTAMPTZ constants.

time_tz :
 		TIME "HH:MM[:SS[.dddd]][{+|-}HH:MM]"

The formats following the TIMETZ, and TIMESTAMPTZ keywords 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]]]]]]"