Download PostgreSQL User`s Guide - BITS

Appendix UG1. Date/Time Support
Time Zone
Offset from UTC
Description
ADT
-03:00
Atlantic Daylight Time
NFT
-3:30
Newfoundland Standard Time
NST
-3:30
Newfoundland Standard Time
AST
-4:00
Atlantic Std Time (Canada)
EDT
-4:00
Eastern Daylight Time
ZP4
-4:00
GMT +4 hours
CDT
-5:00
Central Daylight Time
EST
-5:00
Eastern Standard Time
ZP5
-5:00
GMT +5 hours
CST
-6:00
Central Std Time
MDT
-6:00
Mountain Daylight Time
ZP6
-6:00
GMT +6 hours
MST
-7:00
Mountain Standard Time
PDT
-7:00
Pacific Daylight Time
PST
-8:00
Pacific Std Time
YDT
-8:00
Yukon Daylight Time
HDT
-9:00
Hawaii/Alaska Daylight Time
YST
-9:00
Yukon Standard Time
AHST
-10:00
Alaska-Hawaii Std Time
CAT
-10:00
Central Alaska Time
NT
-11:00
Nome Time
IDLW
-12:00
International Date Line, West
Australian Time Zones
Australian time zones and their naming variants account for fully one quarter of all time zones
in the Postgres time zone lookup table. There are two naming conflicts with common time
zones defined in the United States, CST and EST.
If the compiler option USE_AUSTRALIAN_RULES is set then CST and EST will be
interpreted using Australian conventions.
354