Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_TIMEZONE_NAMES

PG_TIMEZONE_NAMES

Updated at: Jul 15, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel