doc-exports/docs/dws/dev/dws_04_0787.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

4.4 KiB

PG_TIMEZONE_NAMES

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

Table 1 PG_TIMEZONE_NAMES columns

Name

Type

Description

name

text

Name of the time zone

abbrev

text

Time zone name abbreviation

utc_offset

interval

Offset from UTC

is_dst

boolean

Whether DST is used. If it is, its value is true. Otherwise, its value is false.