Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Views/ PG_TIMEZONE_NAMES
Updated on 2025-10-09 GMT+08:00
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.
| Column | 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
