Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ PG_TIMEZONE_NAMES
Updated on 2025-08-19 GMT+08:00
PG_TIMEZONE_NAMES
PG_TIMEZONE_NAMES displays all time zone names that can be recognized by SET TIMEZONE, along with their abbreviations, UTC offsets, and daylight saving time (DST) statuses.
| Name | Type | Description |
|---|---|---|
| name | text | Name of the time zone |
| abbrev | text | Abbreviation of the ime zone name |
| utc_offset | interval | Offset from UTC |
| is_dst | boolean | Whether DST is used. If DST is used, the value is true. Otherwise, the value is false. |
Parent topic: Other System Views
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.
