• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_TIMEZONE_NAMES

PG_TIMEZONE_NAMES

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

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.