B.2. ����/ʱ��ؼ���

Table B-1 ��ʾ�˱������·�������д�ļǺš�

Table B-1. �·�����

�·���д
JanuaryJan
FebruaryFeb
MarchMar
AprilApr
May 
JuneJun
JulyJul
AugustAug
SeptemberSep, Sept
OctoberOct
NovemberNov
DecemberDec

Table B-2 ��ʾ�˱�ʶ��Ϊ���ڼ������֡�

Table B-2. ���ڼ�������

������д
SundaySun
MondayMon
TuesdayTue, Tues
WednesdayWed, Weds
ThursdayThu, Thur, Thurs
FridayFri
SaturdaySat

Table B-3 ��ʾ�����ڸ���������;�ļǺš�

Table B-3. ����/ʱ���ֶ����δ�

��ʶ������
ABSTIME����
AM12:00 ֮ǰ��ʱ��
AT����
JULIAN, JD, J��һ�ֶ�����������
ON����
PM12:00 �� 12:00 ֮���ʱ��
T��һ���ֶ���ʱ��

�ؼ��� ABSTIME ��������������ʷԭ�� �ڷdz��ϵ� PostgreSQL �汾� ����Ϊ abstime �Ƿ����ֶλᱻ���� Invalid Abstime �������������ڲ����������ˣ� ��������ؼ��ֿ�����δ���汾�б�ɾ����

Table B-4 ��ʾ�� PostgreSQL ����ʶ��Ϊ���ڵ��������ֵ֮ʱ����д�� ��ע����Щ������һ���DZ�����������/ʱ����� — �����ʾ���ɵ�ǰѡ���� timezone �������������ġ� �������İ汾�ܿ���Ҳ�� timezone �������롣��

���������������� UTC ��ʱ��ƫ��������֯�ģ������ǰ�����ĸ˳�� ���ǵ�Ŀ������ʵ��ƥ����Щ����������Щ��д�������û��� ������Щ��д������

Table B-4. �����ʱ����д

ʱ���� UTC ��ƫ��������
NZDT+13:00��������ʱ��
IDLE+12:00�������ڱ���ߣ�����
NZST+12:00��������׼ʱ��
NZT+12:00������ʱ��
AESST+11:00�Ĵ����Ƕ�����׼��ʱ��
ACSST+10:30�аĴ����DZ�׼��ʱ��
CADT+10:30�аĴ�������ʱ��
SADT+10:30�ϰĴ�������ʱ��
AEST+10:00�Ĵ����Ƕ�����׼ʱ��
EAST+10:00���Ĵ����DZ�׼ʱ��
GST+10:00�ص���׼ʱ�䣬����˹ʱ�� 9
LIGT+10:00�Ĵ�����ī����
SAST+09:30�ϰĴ����DZ�׼ʱ��
CAST+09:30�аĴ����DZ�׼ʱ��
AWSST+09:00�Ĵ�����������׼��ʱ��
JST+09:00�ձ���׼ʱ�䣬������˹ʱ�� 8��
KST+09:00������׼ʱ��
MHT+09:00����ֵ�ʱ��
WDT+09:00���Ĵ�������ʱ��
MT+08:30ë����˹(moluccas)ʱ�䣨����
AWST+08:00 �Ĵ�����������׼ʱ��
CCT+08:00 �й��غ�ʱ��
WADT+08:00���Ĵ�������ʱ��
WST+08:00���Ĵ����DZ�׼ʱ��
JT+07:30צ��ʱ��
ALMST+07:00Almaty ����ʱ
WAST+07:00���Ĵ����DZ�׼ʱ��
CXT+07:00Christmas (����ڣ�)��ʱ��
MMT+06:30Myannar ʱ��
ALMT+06:00Almaty ʱ��
MAWT+06:00Mawson (Antarctica) Time
IOT+05:00ӡ�� Chagos ʱ��
MVT+05:00Maldives (?)��ʱ��
TFT+05:00Kerguelen ʱ��
AFT+04:30������ʱ��
EAST+04:00Antananarivo Summer Time
MUT+04:00Mauritius Island Time
RET+04:00Reunion Island Time
SCT+04:00Mahe Island Time
IRT, IT+03:30����ʱ��
EAT+03:00Antananarivo, Comoro Time
BT+03:00 �͸��ʱ��
EETDST+03:00 ��ŷ��ʱ��
HMT+03:00Hellas Mediterranean Time (?)
BDST+02:00 British Double Summer Time
CEST+02:00 ��ŷ����ʱ
CETDST+02:00 ��ŷ��ʱ��
EET+02:00 ��ŷ�������ʱ�� 1��
FWT+02:00������ʱ��
IST+02:00��ɫ�б�׼ʱ��
MEST+02:00��ŷ��ʱ��
METDST+02:00��ŷ����ʱ��
SST+02:00�����ʱ��
BST+01:00 Ӣ����ʱ��
CET+01:00 ��ŷʱ��
DNT+01:00 Dansk Normal Tid
FST+01:00 ������ʱ��
MET+01:00��ŷʱ��
MEWT+01:00��ŷ��ʱ��
MEZ+01:00Mitteleurop��sche Zeit
NOR+01:00Ų����׼ʱ��
SET+01:00Seychelles Time������
SWT+01:00��䶬ʱ��
WETDST+01:00��ŷ��������ʱ�䣨��ʱ�ƣ�
GMT0:00�������α�׼ʱ��
UT+00:00ȫ��ʱ��
UTC+00:00У׼��ȫ��ʱ��
z+00:00�� UTC ��ͬ
ZULU+00:00�� UTC ��ͬ
WET+00:00��ŷʱ��
WAT-01:00����ʱ��
FNST-01:00Fernando de Noronha ����ʱ
FNT-02:00Fernando de Noronha ʱ��
BRST-02:00��������ʱ
NDT-02:30Ŧ������Newfoundland������ʱ��
ADT-03:00 ���������ʱ��
AWT-03:00(δ֪)
BRT-03:00����ʱ��
NFT-03:30Ŧ������Newfoundland����׼ʱ��
NST-03:30Ŧ������Newfoundland����׼ʱ��
AST-04:00 �������׼ʱ�䣨���ô�
ACST-04:00Atlantic/Porto Acre ����ʱ
EDT-04:00 ��������ʱ��
ACT-05:00Atlantic/Porto Acre Standard Time
CDT-05:00 �в�����ʱ��
EST-05:00 ������׼ʱ��
CST-06:00 �в���׼ʱ��
MDT-06:00ɽ������ʱ�䣨��ע��Mountain Daylight Time��λ֪����ô�룿��
MST-07:00ɽ����׼ʱ��
PDT-07:00̫ƽ�����ʱ��
AKDT-08:00����˹�Ӱ���ʱ��
PST-08:00̫ƽ���׼ʱ��
YDT-08:00Yukon ����ʱ��
AKST-09:00����˹�ӱ�׼ʱ��
HDT-09:00������/����˹�Ӱ���ʱ��
YST-09:00Yukon ��׼ʱ
MART-09:30�����˾Ⱥ��ʱ��
AHST-10:00����˹��/�����ı�׼ʱ��
HST-10:00�����ı�׼ʱ��
CAT-10:00�а���˹��ʱ��
NT-11:00��ʱ�䣨Nome Time��
IDLW-12:00�������ڱ���ߣ�����

�Ĵ�����ʱ��. �Ĵ�����ʱ�������ϱ������õ�ʱ����֮����������ͻ�� ACST��CST���� EST�� ����������ʱѡ��australian_timezones����ô ACST ��EST �� SAT ��������Ϊ�Ĵ�����ʱ�������֡� �� Table B-5 ��ʾ�� �����Ϊ�٣�ȱʡ����ACST �� EST �� �����ͳ�����ʱ�����֣���SAT ���� ��ʾ"Saturday(������)"�������ַ���

Table B-5. �Ĵ�����ʱ��������д

ʱ���� UTC ��ƫ��������
ACST+09:30�аĴ����DZ�׼ʱ��
CST+10:30�Ĵ������в���׼ʱ��
EST+10:00�Ĵ����Ƕ�����׼ʱ��
SAT+09:30�ϰĴ����DZ�׼ʱ��

Table B-6 ��ʾ�� PostgreSQL ����ʶ��Ŀ����� timezone ��������Чʱ�����֡� ��ע����Щ���ָ����Ϻ�ʵ���϶��� Table B-4 ������ʾ�IJ�ͬ�� ��Щ���ִ�������̺�һ�����ص���ʱ�ƹ��򣬶�ǰ�ߵ�����ֻ�Ƿ�ӳһ���� UTC ��ƫ�ơ�

����ೡ���£�ͬһ��ʱ���ɶ����Ч�����֡�������ͬһ�����г��� �����������ǰ��ո�ʱ������Ҫ����������ġ�

Table B-6. ����timezone��ʱ����

ʱ��
Africa/Abidjan
Africa/Accra
Africa/Addis_Ababa
Africa/Algiers
Africa/Asmera
Africa/Bamako
Africa/Bangui
Africa/Banjul
Africa/Bissau
Africa/Blantyre
Africa/Brazzaville
Africa/Bujumbura
Africa/Cairo Egypt
Africa/Casablanca
Africa/Ceuta
Africa/Conakry
Africa/Dakar
Africa/Dar_es_Salaam
Africa/Djibouti
Africa/Douala
Africa/El_Aaiun
Africa/Freetown
Africa/Gaborone
Africa/Harare
Africa/Johannesburg
Africa/Kampala
Africa/Khartoum
Africa/Kigali
Africa/Kinshasa
Africa/Lagos
Africa/Libreville
Africa/Lome
Africa/Luanda
Africa/Lubumbashi
Africa/Lusaka
Africa/Malabo
Africa/Maputo
Africa/Maseru
Africa/Mbabane
Africa/Mogadishu
Africa/Monrovia
Africa/Nairobi
Africa/Ndjamena
Africa/Niamey
Africa/Nouakchott
Africa/Ouagadougou
Africa/Porto-Novo
Africa/Sao_Tome
Africa/Timbuktu
Africa/Tripoli Libya
Africa/Tunis
Africa/Windhoek
America/Adak America/Atka US/Aleutian
America/Anchorage SystemV/YST9YDT US/Alaska
America/Anguilla
America/Antigua
America/Araguaina
America/Aruba
America/Asuncion
America/Bahia
America/Barbados
America/Belem
America/Belize
America/Boa_Vista
America/Bogota
America/Boise
America/Buenos_Aires
America/Cambridge_Bay
America/Campo_Grande
America/Cancun
America/Caracas
America/Catamarca
America/Cayenne
America/Cayman
America/Chicago CST6CDT SystemV/CST6CDT US/Central
America/Chihuahua
America/Cordoba America/Rosario
America/Costa_Rica
America/Cuiaba
America/Curacao
America/Danmarkshavn
America/Dawson
America/Dawson_Creek
America/Denver MST7MDT SystemV/MST7MDT US/Mountain America/Shiprock Navajo
America/Detroit US/Michigan
America/Dominica
America/Edmonton Canada/Mountain
America/Eirunepe
America/El_Salvador
America/Ensenada America/Tijuana Mexico/BajaNorte
America/Fortaleza
America/Glace_Bay
America/Godthab
America/Goose_Bay
America/Grand_Turk
America/Grenada
America/Guadeloupe
America/Guatemala
America/Guayaquil
America/Guyana
America/Halifax Canada/Atlantic SystemV/AST4ADT
America/Havana Cuba
America/Hermosillo
America/Indiana/Indianapolis America/Indianapolis America/Fort_Wayne EST SystemV/EST5 US/East-Indiana
America/Indiana/Knox America/Knox_IN US/Indiana-Starke
America/Indiana/Marengo
America/Indiana/Vevay
America/Inuvik
America/Iqaluit
America/Jamaica Jamaica
America/Jujuy
America/Juneau
America/Kentucky/Louisville America/Louisville
America/Kentucky/Monticello
America/La_Paz
America/Lima
America/Los_Angeles PST8PDT SystemV/PST8PDT US/Pacific US/Pacific-New
America/Maceio
America/Managua
America/Manaus Brazil/West
America/Martinique
America/Mazatlan Mexico/BajaSur
America/Mendoza
America/Menominee
America/Merida
America/Mexico_City Mexico/General
America/Miquelon
America/Monterrey
America/Montevideo
America/Montreal
America/Montserrat
America/Nassau
America/New_York EST5EDT SystemV/EST5EDT US/Eastern
America/Nipigon
America/Nome
America/Noronha Brazil/DeNoronha
America/North_Dakota/Center
America/Panama
America/Pangnirtung
America/Paramaribo
America/Phoenix MST SystemV/MST7 US/Arizona
America/Port-au-Prince
America/Port_of_Spain
America/Porto_Acre America/Rio_Branco Brazil/Acre
America/Porto_Velho
America/Puerto_Rico SystemV/AST4
America/Rainy_River
America/Rankin_Inlet
America/Recife
America/Regina Canada/East-Saskatchewan Canada/Saskatchewan SystemV/CST6
America/Santiago Chile/Continental
America/Santo_Domingo
America/Sao_Paulo Brazil/East
America/Scoresbysund
America/St_Johns Canada/Newfoundland
America/St_Kitts
America/St_Lucia
America/St_Thomas America/Virgin
America/St_Vincent
America/Swift_Current
America/Tegucigalpa
America/Thule
America/Thunder_Bay
America/Toronto Canada/Eastern
America/Tortola
America/Vancouver Canada/Pacific
America/Whitehorse Canada/Yukon
America/Winnipeg Canada/Central
America/Yakutat
America/Yellowknife
Antarctica/Casey
Antarctica/Davis
Antarctica/DumontDUrville
Antarctica/Mawson
Antarctica/McMurdo Antarctica/South_Pole
Antarctica/Palmer
Antarctica/Rothera
Antarctica/Syowa
Antarctica/Vostok
Asia/Aden
Asia/Almaty
Asia/Amman
Asia/Anadyr
Asia/Aqtau
Asia/Aqtobe
Asia/Ashgabat Asia/Ashkhabad
Asia/Baghdad
Asia/Bahrain
Asia/Baku
Asia/Bangkok
Asia/Beirut
Asia/Bishkek
Asia/Brunei
Asia/Calcutta
Asia/Choibalsan
Asia/Chongqing Asia/Chungking
Asia/Colombo
Asia/Dacca Asia/Dhaka
Asia/Damascus
Asia/Dili
Asia/Dubai
Asia/Dushanbe
Asia/Gaza
Asia/Harbin
Asia/Hong_Kong Hongkong
Asia/Hovd
Asia/Irkutsk
Asia/Jakarta
Asia/Jayapura
Asia/Jerusalem Asia/Tel_Aviv Israel
Asia/Kabul
Asia/Kamchatka
Asia/Karachi
Asia/Kashgar
Asia/Katmandu
Asia/Krasnoyarsk
Asia/Kuala_Lumpur
Asia/Kuching
Asia/Kuwait
Asia/Macao Asia/Macau
Asia/Magadan
Asia/Makassar Asia/Ujung_Pandang
Asia/Manila
Asia/Muscat
Asia/Nicosia Europe/Nicosia
Asia/Novosibirsk
Asia/Omsk
Asia/Oral
Asia/Phnom_Penh
Asia/Pontianak
Asia/Pyongyang
Asia/Qatar
Asia/Qyzylorda
Asia/Rangoon
Asia/Riyadh
Asia/Riyadh87 Mideast/Riyadh87
Asia/Riyadh88 Mideast/Riyadh88
Asia/Riyadh89 Mideast/Riyadh89
Asia/Saigon
Asia/Sakhalin
Asia/Samarkand
Asia/Seoul ROK
Asia/Shanghai PRC
Asia/Singapore Singapore
Asia/Taipei ROC
Asia/Tashkent
Asia/Tbilisi
Asia/Tehran Iran
Asia/Thimbu Asia/Thimphu
Asia/Tokyo Japan
Asia/Ulaanbaatar Asia/Ulan_Bator
Asia/Urumqi
Asia/Vientiane
Asia/Vladivostok
Asia/Yakutsk
Asia/Yekaterinburg
Asia/Yerevan
Atlantic/Azores
Atlantic/Bermuda
Atlantic/Canary
Atlantic/Cape_Verde
Atlantic/Faeroe
Atlantic/Madeira
Atlantic/Reykjavik Iceland
Atlantic/South_Georgia
Atlantic/St_Helena
Atlantic/Stanley
Australia/ACT Australia/Canberra Australia/NSW Australia/Sydney
Australia/Adelaide Australia/South
Australia/Brisbane Australia/Queensland
Australia/Broken_Hill Australia/Yancowinna
Australia/Darwin Australia/North
Australia/Hobart Australia/Tasmania
Australia/LHI Australia/Lord_Howe
Australia/Lindeman
Australia/Melbourne Australia/Victoria
Australia/Perth Australia/West
CET
EET
Etc/GMT+1
Etc/GMT+2
Etc/GMT+3
Etc/GMT+4
Etc/GMT+5
Etc/GMT+6
Etc/GMT+7
Etc/GMT+8
Etc/GMT+9
Etc/GMT+10
Etc/GMT+11
Etc/GMT+12
Etc/GMT-1
Etc/GMT-2
Etc/GMT-3
Etc/GMT-4
Etc/GMT-5
Etc/GMT-6
Etc/GMT-7
Etc/GMT-8
Etc/GMT-9
Etc/GMT-10
Etc/GMT-11
Etc/GMT-12
Etc/GMT-13
Etc/GMT-14
Europe/Amsterdam
Europe/Andorra
Europe/Athens
Europe/Belfast
Europe/Belgrade Europe/Ljubljana Europe/Sarajevo Europe/Skopje Europe/Zagreb
Europe/Berlin
Europe/Brussels
Europe/Bucharest
Europe/Budapest
Europe/Chisinau Europe/Tiraspol
Europe/Copenhagen
Europe/Dublin Eire
Europe/Gibraltar
Europe/Helsinki
Europe/Istanbul Asia/Istanbul Turkey
Europe/Kaliningrad
Europe/Kiev
Europe/Lisbon Portugal
Europe/London GB GB-Eire
Europe/Luxembourg
Europe/Madrid
Europe/Malta
Europe/Minsk
Europe/Monaco
Europe/Moscow W-SU
Europe/Oslo Arctic/Longyearbyen Atlantic/Jan_Mayen
Europe/Paris
Europe/Prague Europe/Bratislava
Europe/Riga
Europe/Rome Europe/San_Marino Europe/Vatican
Europe/Samara
Europe/Simferopol
Europe/Sofia
Europe/Stockholm
Europe/Tallinn
Europe/Tirane
Europe/Uzhgorod
Europe/Vaduz
Europe/Vienna
Europe/Vilnius
Europe/Warsaw Poland
Europe/Zaporozhye
Europe/Zurich
Factory
GMT GMT+0 GMT-0 GMT0 Greenwich Etc/GMT Etc/GMT+0 Etc/GMT-0 Etc/GMT0 Etc/Greenwich
Indian/Antananarivo
Indian/Chagos
Indian/Christmas
Indian/Cocos
Indian/Comoro
Indian/Kerguelen
Indian/Mahe
Indian/Maldives
Indian/Mauritius
Indian/Mayotte
Indian/Reunion
MET
Pacific/Apia
Pacific/Auckland NZ
Pacific/Chatham NZ-CHAT
Pacific/Easter Chile/EasterIsland
Pacific/Efate
Pacific/Enderbury
Pacific/Fakaofo
Pacific/Fiji
Pacific/Funafuti
Pacific/Galapagos
Pacific/Gambier SystemV/YST9
Pacific/Guadalcanal
Pacific/Guam
Pacific/Honolulu HST SystemV/HST10 US/Hawaii
Pacific/Johnston
Pacific/Kiritimati
Pacific/Kosrae
Pacific/Kwajalein Kwajalein
Pacific/Majuro
Pacific/Marquesas
Pacific/Midway
Pacific/Nauru
Pacific/Niue
Pacific/Norfolk
Pacific/Noumea
Pacific/Pago_Pago Pacific/Samoa US/Samoa
Pacific/Palau
Pacific/Pitcairn SystemV/PST8
Pacific/Ponape
Pacific/Port_Moresby
Pacific/Rarotonga
Pacific/Saipan
Pacific/Tahiti
Pacific/Tarawa
Pacific/Tongatapu
Pacific/Truk
Pacific/Wake
Pacific/Wallis
Pacific/Yap
UCT Etc/UCT
UTC Universal Zulu Etc/UTC Etc/Universal Etc/Zulu
WET

���˱����г��������⣬PostgreSQL ���������磺 STDoffset ���� STDoffsetDST ��ʱ�������룬 ����� STD ��һ��ʱ����д��offset ��һ��һСʱ�Ƶ� UTC ��������ֵƫ�ƣ� DST ��һ����ѡ����ʱ��ʱ����д�������ʾΪ�ȸ�����ƫ����һ��Сʱ�� ���磬��� EST5EDT û�б�����ʱ����ʶ����ô��Ҳ�ᱻ���ܣ����ҹ����ϵ��� USA �Ķ�����ʱ�䡣 �ڳ���һ��Сʱ֮ʱ������ʱ����ô����ʹ�ü���Ϊ�Ǹ��� USA ʱ��������еģ� ��ˣ�������Զ��ڱ���֮��ĵط���;�������ǻ�Ҫע����ǣ�������������ܻᵼ�²�������ؽ���������������룬 ���û�ж�ʱ����д�Ƿ��к�����м�顣���磬SET TIMEZONE TO FOOBAR0 �ǿ������еģ� �����ϵͳʹ����һ��������� GMT ����д��