PG_TIMEZONE_NAMES

PG_TIMEZONE_NAMES provides all time zone names that can be recognized by SET TIMEZONE, along with their abbreviations, UTC offsets, and daylight saving time (DST) statuses.

Table 1 PG_TIMEZONE_NAMES columns

Name

Type

Description

name

text

Name of the time zone

abbrev

text

Abbreviation of the ime zone name

utc_offset

interval

Offset from UTC

is_dst

Boolean

Whether DST is used. If DST is used, the value is true. Otherwise, the value is false.

Feedback
编组 3备份
    openGauss 2024-07-23 01:01:16
    cancel