Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ 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 time zone name. |
| utc_offset | interval | Offset from UTC. |
| is_dst | Boolean | Specifies whether the DST is being used. If the DST is being used, the value is TRUE; otherwise, the value is FALSE. |
Parent topic: 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.
