• Data Warehouse Service

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

PG_TIMEZONE_ABBREVS

PG_TIMEZONE_ABBREVS provides all time zone abbreviations that can be recognized by the input routines.

Table 1 PG_TIMEZONE_ABBREVS columns

Name

Type

Description

abbrev

text

Time zone abbreviation

utc_offset

interval

Offset from UTC

is_dst

Boolean

Whether the abbreviation indicates a daylight saving time (DST) zone. If it does, its value is true. Otherwise, its value is false.