Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> PG_TIMEZONE_NAMES
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.
| 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. |
Parent topic: System Views
Last Article: PG_TIMEZONE_ABBREVS
Next Article: PG_TOTAL_MEMORY_DETAIL
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.