time_tz

The following syntax shows the formats for TIME_TZ and TIMESTAMP_TZ constants.

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

The formats following the TIME_TZ, and TIMESTAMP_TZ 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]]]]]]"