Created
April 24, 2014 08:05
-
-
Save justqyx/11245900 to your computer and use it in GitHub Desktop.
select * from pg_timezone_names;
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | abbrev | utc_offset | is_dst | |
| ----------------------------------+--------+------------+-------- | |
| Africa/Abidjan | GMT | 00:00:00 | f | |
| Africa/Accra | GMT | 00:00:00 | f | |
| Africa/Addis_Ababa | EAT | 03:00:00 | f | |
| Africa/Algiers | CET | 01:00:00 | f | |
| Africa/Asmara | EAT | 03:00:00 | f | |
| Africa/Asmera | EAT | 03:00:00 | f | |
| Africa/Bamako | GMT | 00:00:00 | f | |
| Africa/Bangui | WAT | 01:00:00 | f | |
| Africa/Banjul | GMT | 00:00:00 | f | |
| Africa/Bissau | GMT | 00:00:00 | f | |
| Africa/Blantyre | CAT | 02:00:00 | f | |
| Africa/Brazzaville | WAT | 01:00:00 | f | |
| Africa/Bujumbura | CAT | 02:00:00 | f | |
| Africa/Cairo | EET | 02:00:00 | f | |
| Africa/Casablanca | WEST | 01:00:00 | t | |
| Africa/Ceuta | CEST | 02:00:00 | t | |
| Africa/Conakry | GMT | 00:00:00 | f | |
| Africa/Dakar | GMT | 00:00:00 | f | |
| Africa/Dar_es_Salaam | EAT | 03:00:00 | f | |
| Africa/Djibouti | EAT | 03:00:00 | f | |
| Africa/Douala | WAT | 01:00:00 | f | |
| Africa/El_Aaiun | WEST | 01:00:00 | t | |
| Africa/Freetown | GMT | 00:00:00 | f | |
| Africa/Gaborone | CAT | 02:00:00 | f | |
| Africa/Harare | CAT | 02:00:00 | f | |
| Africa/Johannesburg | SAST | 02:00:00 | f | |
| Africa/Juba | EAT | 03:00:00 | f | |
| Africa/Kampala | EAT | 03:00:00 | f | |
| Africa/Khartoum | EAT | 03:00:00 | f | |
| Africa/Kigali | CAT | 02:00:00 | f | |
| Africa/Kinshasa | WAT | 01:00:00 | f | |
| Africa/Lagos | WAT | 01:00:00 | f | |
| Africa/Libreville | WAT | 01:00:00 | f | |
| Africa/Lome | GMT | 00:00:00 | f | |
| Africa/Luanda | WAT | 01:00:00 | f | |
| Africa/Lubumbashi | CAT | 02:00:00 | f | |
| Africa/Lusaka | CAT | 02:00:00 | f | |
| Africa/Malabo | WAT | 01:00:00 | f | |
| Africa/Maputo | CAT | 02:00:00 | f | |
| Africa/Maseru | SAST | 02:00:00 | f | |
| Africa/Mbabane | SAST | 02:00:00 | f | |
| Africa/Mogadishu | EAT | 03:00:00 | f | |
| Africa/Monrovia | GMT | 00:00:00 | f | |
| Africa/Nairobi | EAT | 03:00:00 | f | |
| Africa/Ndjamena | WAT | 01:00:00 | f | |
| Africa/Niamey | WAT | 01:00:00 | f | |
| Africa/Nouakchott | GMT | 00:00:00 | f | |
| Africa/Ouagadougou | GMT | 00:00:00 | f | |
| Africa/Porto-Novo | WAT | 01:00:00 | f | |
| Africa/Sao_Tome | GMT | 00:00:00 | f | |
| Africa/Timbuktu | GMT | 00:00:00 | f | |
| Africa/Tripoli | EET | 02:00:00 | f | |
| Africa/Tunis | CET | 01:00:00 | f | |
| Africa/Windhoek | WAT | 01:00:00 | f | |
| America/Adak | HADT | -09:00:00 | t | |
| America/Anchorage | AKDT | -08:00:00 | t | |
| America/Anguilla | AST | -04:00:00 | f | |
| America/Antigua | AST | -04:00:00 | f | |
| America/Araguaina | BRT | -03:00:00 | f | |
| America/Argentina/Buenos_Aires | ART | -03:00:00 | f | |
| America/Argentina/Catamarca | ART | -03:00:00 | f | |
| America/Argentina/ComodRivadavia | ART | -03:00:00 | f | |
| America/Argentina/Cordoba | ART | -03:00:00 | f | |
| America/Argentina/Jujuy | ART | -03:00:00 | f | |
| America/Argentina/La_Rioja | ART | -03:00:00 | f | |
| America/Argentina/Mendoza | ART | -03:00:00 | f | |
| America/Argentina/Rio_Gallegos | ART | -03:00:00 | f | |
| America/Argentina/Salta | ART | -03:00:00 | f | |
| America/Argentina/San_Juan | ART | -03:00:00 | f | |
| America/Argentina/San_Luis | ART | -03:00:00 | f | |
| America/Argentina/Tucuman | ART | -03:00:00 | f | |
| America/Argentina/Ushuaia | ART | -03:00:00 | f | |
| America/Aruba | AST | -04:00:00 | f | |
| America/Asuncion | PYT | -04:00:00 | f | |
| America/Atikokan | EST | -05:00:00 | f | |
| America/Atka | HADT | -09:00:00 | t | |
| America/Bahia | BRT | -03:00:00 | f | |
| America/Bahia_Banderas | CDT | -05:00:00 | t | |
| America/Barbados | AST | -04:00:00 | f | |
| America/Belem | BRT | -03:00:00 | f | |
| America/Belize | CST | -06:00:00 | f | |
| America/Blanc-Sablon | AST | -04:00:00 | f | |
| America/Boa_Vista | AMT | -04:00:00 | f | |
| America/Bogota | COT | -05:00:00 | f | |
| America/Boise | MDT | -06:00:00 | t | |
| America/Buenos_Aires | ART | -03:00:00 | f | |
| America/Cambridge_Bay | MDT | -06:00:00 | t | |
| America/Campo_Grande | AMT | -04:00:00 | f | |
| America/Cancun | CDT | -05:00:00 | t | |
| America/Caracas | VET | -04:30:00 | f | |
| America/Catamarca | ART | -03:00:00 | f | |
| America/Cayenne | GFT | -03:00:00 | f | |
| America/Cayman | EST | -05:00:00 | f | |
| America/Chicago | CDT | -05:00:00 | t | |
| America/Chihuahua | MDT | -06:00:00 | t | |
| America/Coral_Harbour | EST | -05:00:00 | f | |
| America/Cordoba | ART | -03:00:00 | f | |
| America/Costa_Rica | CST | -06:00:00 | f | |
| America/Creston | MST | -07:00:00 | f | |
| America/Cuiaba | AMT | -04:00:00 | f | |
| America/Curacao | AST | -04:00:00 | f | |
| America/Danmarkshavn | GMT | 00:00:00 | f | |
| America/Dawson | PDT | -07:00:00 | t | |
| America/Dawson_Creek | MST | -07:00:00 | f | |
| America/Denver | MDT | -06:00:00 | t | |
| America/Detroit | EDT | -04:00:00 | t | |
| America/Dominica | AST | -04:00:00 | f | |
| America/Edmonton | MDT | -06:00:00 | t | |
| America/Eirunepe | ACT | -05:00:00 | f | |
| America/El_Salvador | CST | -06:00:00 | f | |
| America/Ensenada | PDT | -07:00:00 | t | |
| America/Fort_Wayne | EDT | -04:00:00 | t | |
| America/Fortaleza | BRT | -03:00:00 | f | |
| America/Glace_Bay | ADT | -03:00:00 | t | |
| America/Godthab | WGST | -02:00:00 | t | |
| America/Goose_Bay | ADT | -03:00:00 | t | |
| America/Grand_Turk | EDT | -04:00:00 | t | |
| America/Grenada | AST | -04:00:00 | f | |
| America/Guadeloupe | AST | -04:00:00 | f | |
| America/Guatemala | CST | -06:00:00 | f | |
| America/Guayaquil | ECT | -05:00:00 | f | |
| America/Guyana | GYT | -04:00:00 | f | |
| America/Halifax | ADT | -03:00:00 | t | |
| America/Havana | CDT | -04:00:00 | t | |
| America/Hermosillo | MST | -07:00:00 | f | |
| America/Indiana/Indianapolis | EDT | -04:00:00 | t | |
| America/Indiana/Knox | CDT | -05:00:00 | t | |
| America/Indiana/Marengo | EDT | -04:00:00 | t | |
| America/Indiana/Petersburg | EDT | -04:00:00 | t | |
| America/Indiana/Tell_City | CDT | -05:00:00 | t | |
| America/Indiana/Vevay | EDT | -04:00:00 | t | |
| America/Indiana/Vincennes | EDT | -04:00:00 | t | |
| America/Indiana/Winamac | EDT | -04:00:00 | t | |
| America/Indianapolis | EDT | -04:00:00 | t | |
| America/Inuvik | MDT | -06:00:00 | t | |
| America/Iqaluit | EDT | -04:00:00 | t | |
| America/Jamaica | EST | -05:00:00 | f | |
| America/Jujuy | ART | -03:00:00 | f | |
| America/Juneau | AKDT | -08:00:00 | t | |
| America/Kentucky/Louisville | EDT | -04:00:00 | t | |
| America/Kentucky/Monticello | EDT | -04:00:00 | t | |
| America/Knox_IN | CDT | -05:00:00 | t | |
| America/Kralendijk | AST | -04:00:00 | f | |
| America/La_Paz | BOT | -04:00:00 | f | |
| America/Lima | PET | -05:00:00 | f | |
| America/Los_Angeles | PDT | -07:00:00 | t | |
| America/Louisville | EDT | -04:00:00 | t | |
| America/Lower_Princes | AST | -04:00:00 | f | |
| America/Maceio | BRT | -03:00:00 | f | |
| America/Managua | CST | -06:00:00 | f | |
| America/Manaus | AMT | -04:00:00 | f | |
| America/Marigot | AST | -04:00:00 | f | |
| America/Martinique | AST | -04:00:00 | f | |
| America/Matamoros | CDT | -05:00:00 | t | |
| America/Mazatlan | MDT | -06:00:00 | t | |
| America/Mendoza | ART | -03:00:00 | f | |
| America/Menominee | CDT | -05:00:00 | t | |
| America/Merida | CDT | -05:00:00 | t | |
| America/Metlakatla | MeST | -08:00:00 | f | |
| America/Mexico_City | CDT | -05:00:00 | t | |
| America/Miquelon | PMDT | -02:00:00 | t | |
| America/Moncton | ADT | -03:00:00 | t | |
| America/Monterrey | CDT | -05:00:00 | t | |
| America/Montevideo | UYT | -03:00:00 | f | |
| America/Montreal | EDT | -04:00:00 | t | |
| America/Montserrat | AST | -04:00:00 | f | |
| America/Nassau | EDT | -04:00:00 | t | |
| America/New_York | EDT | -04:00:00 | t | |
| America/Nipigon | EDT | -04:00:00 | t | |
| America/Nome | AKDT | -08:00:00 | t | |
| America/Noronha | FNT | -02:00:00 | f | |
| America/North_Dakota/Beulah | CDT | -05:00:00 | t | |
| America/North_Dakota/Center | CDT | -05:00:00 | t | |
| America/North_Dakota/New_Salem | CDT | -05:00:00 | t | |
| America/Ojinaga | MDT | -06:00:00 | t | |
| America/Panama | EST | -05:00:00 | f | |
| America/Pangnirtung | EDT | -04:00:00 | t | |
| America/Paramaribo | SRT | -03:00:00 | f | |
| America/Phoenix | MST | -07:00:00 | f | |
| America/Port-au-Prince | EDT | -04:00:00 | t | |
| America/Port_of_Spain | AST | -04:00:00 | f | |
| America/Porto_Acre | ACT | -05:00:00 | f | |
| America/Porto_Velho | AMT | -04:00:00 | f | |
| America/Puerto_Rico | AST | -04:00:00 | f | |
| America/Rainy_River | CDT | -05:00:00 | t | |
| America/Rankin_Inlet | CDT | -05:00:00 | t | |
| America/Recife | BRT | -03:00:00 | f | |
| America/Regina | CST | -06:00:00 | f | |
| America/Resolute | CDT | -05:00:00 | t | |
| America/Rio_Branco | ACT | -05:00:00 | f | |
| America/Rosario | ART | -03:00:00 | f | |
| America/Santa_Isabel | PDT | -07:00:00 | t | |
| America/Santarem | BRT | -03:00:00 | f | |
| America/Santiago | CLST | -03:00:00 | t | |
| America/Santo_Domingo | AST | -04:00:00 | f | |
| America/Sao_Paulo | BRT | -03:00:00 | f | |
| America/Scoresbysund | EGST | 00:00:00 | t | |
| America/Shiprock | MDT | -06:00:00 | t | |
| America/Sitka | AKDT | -08:00:00 | t | |
| America/St_Barthelemy | AST | -04:00:00 | f | |
| America/St_Johns | NDT | -02:30:00 | t | |
| America/St_Kitts | AST | -04:00:00 | f | |
| America/St_Lucia | AST | -04:00:00 | f | |
| America/St_Thomas | AST | -04:00:00 | f | |
| America/St_Vincent | AST | -04:00:00 | f | |
| America/Swift_Current | CST | -06:00:00 | f | |
| America/Tegucigalpa | CST | -06:00:00 | f | |
| America/Thule | ADT | -03:00:00 | t | |
| America/Thunder_Bay | EDT | -04:00:00 | t | |
| America/Tijuana | PDT | -07:00:00 | t | |
| America/Toronto | EDT | -04:00:00 | t | |
| America/Tortola | AST | -04:00:00 | f | |
| America/Vancouver | PDT | -07:00:00 | t | |
| America/Virgin | AST | -04:00:00 | f | |
| America/Whitehorse | PDT | -07:00:00 | t | |
| America/Winnipeg | CDT | -05:00:00 | t | |
| America/Yakutat | AKDT | -08:00:00 | t | |
| America/Yellowknife | MDT | -06:00:00 | t | |
| Antarctica/Casey | WST | 08:00:00 | f | |
| Antarctica/Davis | DAVT | 07:00:00 | f | |
| Antarctica/DumontDUrville | DDUT | 10:00:00 | f | |
| Antarctica/Macquarie | MIST | 11:00:00 | f | |
| Antarctica/Mawson | MAWT | 05:00:00 | f | |
| Antarctica/McMurdo | NZST | 12:00:00 | f | |
| Antarctica/Palmer | CLST | -03:00:00 | t | |
| Antarctica/Rothera | ROTT | -03:00:00 | f | |
| Antarctica/South_Pole | NZST | 12:00:00 | f | |
| Antarctica/Syowa | SYOT | 03:00:00 | f | |
| Antarctica/Vostok | VOST | 06:00:00 | f | |
| Arctic/Longyearbyen | CEST | 02:00:00 | t | |
| Asia/Aden | AST | 03:00:00 | f | |
| Asia/Almaty | ALMT | 06:00:00 | f | |
| Asia/Amman | EEST | 03:00:00 | t | |
| Asia/Anadyr | ANAT | 12:00:00 | f | |
| Asia/Aqtau | AQTT | 05:00:00 | f | |
| Asia/Aqtobe | AQTT | 05:00:00 | f | |
| Asia/Ashgabat | TMT | 05:00:00 | f | |
| Asia/Ashkhabad | TMT | 05:00:00 | f | |
| Asia/Baghdad | AST | 03:00:00 | f | |
| Asia/Bahrain | AST | 03:00:00 | f | |
| Asia/Baku | AZST | 05:00:00 | t | |
| Asia/Bangkok | ICT | 07:00:00 | f | |
| Asia/Beirut | EEST | 03:00:00 | t | |
| Asia/Bishkek | KGT | 06:00:00 | f | |
| Asia/Brunei | BNT | 08:00:00 | f | |
| Asia/Calcutta | IST | 05:30:00 | f | |
| Asia/Choibalsan | CHOT | 08:00:00 | f | |
| Asia/Chongqing | CST | 08:00:00 | f | |
| Asia/Chungking | CST | 08:00:00 | f | |
| Asia/Colombo | IST | 05:30:00 | f | |
| Asia/Dacca | BDT | 06:00:00 | f | |
| Asia/Damascus | EEST | 03:00:00 | t | |
| Asia/Dhaka | BDT | 06:00:00 | f | |
| Asia/Dili | TLT | 09:00:00 | f | |
| Asia/Dubai | GST | 04:00:00 | f | |
| Asia/Dushanbe | TJT | 05:00:00 | f | |
| Asia/Gaza | EEST | 03:00:00 | t | |
| Asia/Harbin | CST | 08:00:00 | f | |
| Asia/Hebron | EEST | 03:00:00 | t | |
| Asia/Ho_Chi_Minh | ICT | 07:00:00 | f | |
| Asia/Hong_Kong | HKT | 08:00:00 | f | |
| Asia/Hovd | HOVT | 07:00:00 | f | |
| Asia/Irkutsk | IRKT | 09:00:00 | f | |
| Asia/Istanbul | EEST | 03:00:00 | t | |
| Asia/Jakarta | WIB | 07:00:00 | f | |
| Asia/Jayapura | WIT | 09:00:00 | f | |
| Asia/Jerusalem | IDT | 03:00:00 | t | |
| Asia/Kabul | AFT | 04:30:00 | f | |
| Asia/Kamchatka | PETT | 12:00:00 | f | |
| Asia/Karachi | PKT | 05:00:00 | f | |
| Asia/Kashgar | CST | 08:00:00 | f | |
| Asia/Kathmandu | NPT | 05:45:00 | f | |
| Asia/Katmandu | NPT | 05:45:00 | f | |
| Asia/Khandyga | YAKT | 10:00:00 | f | |
| Asia/Kolkata | IST | 05:30:00 | f | |
| Asia/Krasnoyarsk | KRAT | 08:00:00 | f | |
| Asia/Kuala_Lumpur | MYT | 08:00:00 | f | |
| Asia/Kuching | MYT | 08:00:00 | f | |
| Asia/Kuwait | AST | 03:00:00 | f | |
| Asia/Macao | CST | 08:00:00 | f | |
| Asia/Macau | CST | 08:00:00 | f | |
| Asia/Magadan | MAGT | 12:00:00 | f | |
| Asia/Makassar | WITA | 08:00:00 | f | |
| Asia/Manila | PHT | 08:00:00 | f | |
| Asia/Muscat | GST | 04:00:00 | f | |
| Asia/Nicosia | EEST | 03:00:00 | t | |
| Asia/Novokuznetsk | NOVT | 07:00:00 | f | |
| Asia/Novosibirsk | NOVT | 07:00:00 | f | |
| Asia/Omsk | OMST | 07:00:00 | f | |
| Asia/Oral | ORAT | 05:00:00 | f | |
| Asia/Phnom_Penh | ICT | 07:00:00 | f | |
| Asia/Pontianak | WIB | 07:00:00 | f | |
| Asia/Pyongyang | KST | 09:00:00 | f | |
| Asia/Qatar | AST | 03:00:00 | f | |
| Asia/Qyzylorda | QYZT | 06:00:00 | f | |
| Asia/Rangoon | MMT | 06:30:00 | f | |
| Asia/Riyadh | AST | 03:00:00 | f | |
| Asia/Saigon | ICT | 07:00:00 | f | |
| Asia/Sakhalin | SAKT | 11:00:00 | f | |
| Asia/Samarkand | UZT | 05:00:00 | f | |
| Asia/Seoul | KST | 09:00:00 | f | |
| Asia/Shanghai | CST | 08:00:00 | f | |
| Asia/Singapore | SGT | 08:00:00 | f | |
| Asia/Taipei | CST | 08:00:00 | f | |
| Asia/Tashkent | UZT | 05:00:00 | f | |
| Asia/Tbilisi | GET | 04:00:00 | f | |
| Asia/Tehran | IRDT | 04:30:00 | t | |
| Asia/Tel_Aviv | IDT | 03:00:00 | t | |
| Asia/Thimbu | BTT | 06:00:00 | f | |
| Asia/Thimphu | BTT | 06:00:00 | f | |
| Asia/Tokyo | JST | 09:00:00 | f | |
| Asia/Ujung_Pandang | WITA | 08:00:00 | f | |
| Asia/Ulaanbaatar | ULAT | 08:00:00 | f | |
| Asia/Ulan_Bator | ULAT | 08:00:00 | f | |
| Asia/Urumqi | CST | 08:00:00 | f | |
| Asia/Ust-Nera | VLAT | 11:00:00 | f | |
| Asia/Vientiane | ICT | 07:00:00 | f | |
| Asia/Vladivostok | VLAT | 11:00:00 | f | |
| Asia/Yakutsk | YAKT | 10:00:00 | f | |
| Asia/Yekaterinburg | YEKT | 06:00:00 | f | |
| Asia/Yerevan | AMT | 04:00:00 | f | |
| Atlantic/Azores | AZOST | 00:00:00 | t | |
| Atlantic/Bermuda | ADT | -03:00:00 | t | |
| Atlantic/Canary | WEST | 01:00:00 | t | |
| Atlantic/Cape_Verde | CVT | -01:00:00 | f | |
| Atlantic/Faeroe | WEST | 01:00:00 | t | |
| Atlantic/Faroe | WEST | 01:00:00 | t | |
| Atlantic/Jan_Mayen | CEST | 02:00:00 | t | |
| Atlantic/Madeira | WEST | 01:00:00 | t | |
| Atlantic/Reykjavik | GMT | 00:00:00 | f | |
| Atlantic/South_Georgia | GST | -02:00:00 | f | |
| Atlantic/St_Helena | GMT | 00:00:00 | f | |
| Atlantic/Stanley | FKST | -03:00:00 | f | |
| Australia/ACT | EST | 10:00:00 | f | |
| Australia/Adelaide | CST | 09:30:00 | f | |
| Australia/Brisbane | EST | 10:00:00 | f | |
| Australia/Broken_Hill | CST | 09:30:00 | f | |
| Australia/Canberra | EST | 10:00:00 | f | |
| Australia/Currie | EST | 10:00:00 | f | |
| Australia/Darwin | CST | 09:30:00 | f | |
| Australia/Eucla | CWST | 08:45:00 | f | |
| Australia/Hobart | EST | 10:00:00 | f | |
| Australia/LHI | LHST | 10:30:00 | f | |
| Australia/Lindeman | EST | 10:00:00 | f | |
| Australia/Lord_Howe | LHST | 10:30:00 | f | |
| Australia/Melbourne | EST | 10:00:00 | f | |
| Australia/North | CST | 09:30:00 | f | |
| Australia/NSW | EST | 10:00:00 | f | |
| Australia/Perth | WST | 08:00:00 | f | |
| Australia/Queensland | EST | 10:00:00 | f | |
| Australia/South | CST | 09:30:00 | f | |
| Australia/Sydney | EST | 10:00:00 | f | |
| Australia/Tasmania | EST | 10:00:00 | f | |
| Australia/Victoria | EST | 10:00:00 | f | |
| Australia/West | WST | 08:00:00 | f | |
| Australia/Yancowinna | CST | 09:30:00 | f | |
| Brazil/Acre | ACT | -05:00:00 | f | |
| Brazil/DeNoronha | FNT | -02:00:00 | f | |
| Brazil/East | BRT | -03:00:00 | f | |
| Brazil/West | AMT | -04:00:00 | f | |
| Canada/Atlantic | ADT | -03:00:00 | t | |
| Canada/Central | CDT | -05:00:00 | t | |
| Canada/East-Saskatchewan | CST | -06:00:00 | f | |
| Canada/Eastern | EDT | -04:00:00 | t | |
| Canada/Mountain | MDT | -06:00:00 | t | |
| Canada/Newfoundland | NDT | -02:30:00 | t | |
| Canada/Pacific | PDT | -07:00:00 | t | |
| Canada/Saskatchewan | CST | -06:00:00 | f | |
| Canada/Yukon | PDT | -07:00:00 | t | |
| CET | CEST | 02:00:00 | t | |
| Chile/Continental | CLST | -03:00:00 | t | |
| Chile/EasterIsland | EASST | -05:00:00 | t | |
| CST6CDT | CDT | -05:00:00 | t | |
| Cuba | CDT | -04:00:00 | t | |
| EET | EEST | 03:00:00 | t | |
| Egypt | EET | 02:00:00 | f | |
| Eire | IST | 01:00:00 | t | |
| EST | EST | -05:00:00 | f | |
| EST5EDT | EDT | -04:00:00 | t | |
| Etc/GMT | GMT | 00:00:00 | f | |
| Etc/GMT+0 | GMT | 00:00:00 | f | |
| Etc/GMT+1 | GMT+1 | -01:00:00 | f | |
| Etc/GMT+10 | GMT+10 | -10:00:00 | f | |
| Etc/GMT+11 | GMT+11 | -11:00:00 | f | |
| Etc/GMT+12 | GMT+12 | -12:00:00 | f | |
| Etc/GMT+2 | GMT+2 | -02:00:00 | f | |
| Etc/GMT+3 | GMT+3 | -03:00:00 | f | |
| Etc/GMT+4 | GMT+4 | -04:00:00 | f | |
| Etc/GMT+5 | GMT+5 | -05:00:00 | f | |
| Etc/GMT+6 | GMT+6 | -06:00:00 | f | |
| Etc/GMT+7 | GMT+7 | -07:00:00 | f | |
| Etc/GMT+8 | GMT+8 | -08:00:00 | f | |
| Etc/GMT+9 | GMT+9 | -09:00:00 | f | |
| Etc/GMT-0 | GMT | 00:00:00 | f | |
| Etc/GMT-1 | GMT-1 | 01:00:00 | f | |
| Etc/GMT-10 | GMT-10 | 10:00:00 | f | |
| Etc/GMT-11 | GMT-11 | 11:00:00 | f | |
| Etc/GMT-12 | GMT-12 | 12:00:00 | f | |
| Etc/GMT-13 | GMT-13 | 13:00:00 | f | |
| Etc/GMT-14 | GMT-14 | 14:00:00 | f | |
| Etc/GMT-2 | GMT-2 | 02:00:00 | f | |
| Etc/GMT-3 | GMT-3 | 03:00:00 | f | |
| Etc/GMT-4 | GMT-4 | 04:00:00 | f | |
| Etc/GMT-5 | GMT-5 | 05:00:00 | f | |
| Etc/GMT-6 | GMT-6 | 06:00:00 | f | |
| Etc/GMT-7 | GMT-7 | 07:00:00 | f | |
| Etc/GMT-8 | GMT-8 | 08:00:00 | f | |
| Etc/GMT-9 | GMT-9 | 09:00:00 | f | |
| Etc/GMT0 | GMT | 00:00:00 | f | |
| Etc/Greenwich | GMT | 00:00:00 | f | |
| Etc/UCT | UCT | 00:00:00 | f | |
| Etc/Universal | UTC | 00:00:00 | f | |
| Etc/UTC | UTC | 00:00:00 | f | |
| Etc/Zulu | UTC | 00:00:00 | f | |
| Europe/Amsterdam | CEST | 02:00:00 | t | |
| Europe/Andorra | CEST | 02:00:00 | t | |
| Europe/Athens | EEST | 03:00:00 | t | |
| Europe/Belfast | BST | 01:00:00 | t | |
| Europe/Belgrade | CEST | 02:00:00 | t | |
| Europe/Berlin | CEST | 02:00:00 | t | |
| Europe/Bratislava | CEST | 02:00:00 | t | |
| Europe/Brussels | CEST | 02:00:00 | t | |
| Europe/Bucharest | EEST | 03:00:00 | t | |
| Europe/Budapest | CEST | 02:00:00 | t | |
| Europe/Busingen | CEST | 02:00:00 | t | |
| Europe/Chisinau | EEST | 03:00:00 | t | |
| Europe/Copenhagen | CEST | 02:00:00 | t | |
| Europe/Dublin | IST | 01:00:00 | t | |
| Europe/Gibraltar | CEST | 02:00:00 | t | |
| Europe/Guernsey | BST | 01:00:00 | t | |
| Europe/Helsinki | EEST | 03:00:00 | t | |
| Europe/Isle_of_Man | BST | 01:00:00 | t | |
| Europe/Istanbul | EEST | 03:00:00 | t | |
| Europe/Jersey | BST | 01:00:00 | t | |
| Europe/Kaliningrad | FET | 03:00:00 | f | |
| Europe/Kiev | EEST | 03:00:00 | t | |
| Europe/Lisbon | WEST | 01:00:00 | t | |
| Europe/Ljubljana | CEST | 02:00:00 | t | |
| Europe/London | BST | 01:00:00 | t | |
| Europe/Luxembourg | CEST | 02:00:00 | t | |
| Europe/Madrid | CEST | 02:00:00 | t | |
| Europe/Malta | CEST | 02:00:00 | t | |
| Europe/Mariehamn | EEST | 03:00:00 | t | |
| Europe/Minsk | FET | 03:00:00 | f | |
| Europe/Monaco | CEST | 02:00:00 | t | |
| Europe/Moscow | MSK | 04:00:00 | f | |
| Europe/Nicosia | EEST | 03:00:00 | t | |
| Europe/Oslo | CEST | 02:00:00 | t | |
| Europe/Paris | CEST | 02:00:00 | t | |
| Europe/Podgorica | CEST | 02:00:00 | t | |
| Europe/Prague | CEST | 02:00:00 | t | |
| Europe/Riga | EEST | 03:00:00 | t | |
| Europe/Rome | CEST | 02:00:00 | t | |
| Europe/Samara | SAMT | 04:00:00 | f | |
| Europe/San_Marino | CEST | 02:00:00 | t | |
| Europe/Sarajevo | CEST | 02:00:00 | t | |
| Europe/Simferopol | EEST | 03:00:00 | t | |
| Europe/Skopje | CEST | 02:00:00 | t | |
| Europe/Sofia | EEST | 03:00:00 | t | |
| Europe/Stockholm | CEST | 02:00:00 | t | |
| Europe/Tallinn | EEST | 03:00:00 | t | |
| Europe/Tirane | CEST | 02:00:00 | t | |
| Europe/Tiraspol | EEST | 03:00:00 | t | |
| Europe/Uzhgorod | EEST | 03:00:00 | t | |
| Europe/Vaduz | CEST | 02:00:00 | t | |
| Europe/Vatican | CEST | 02:00:00 | t | |
| Europe/Vienna | CEST | 02:00:00 | t | |
| Europe/Vilnius | EEST | 03:00:00 | t | |
| Europe/Volgograd | VOLT | 04:00:00 | f | |
| Europe/Warsaw | CEST | 02:00:00 | t | |
| Europe/Zagreb | CEST | 02:00:00 | t | |
| Europe/Zaporozhye | EEST | 03:00:00 | t | |
| Europe/Zurich | CEST | 02:00:00 | t | |
| GB | BST | 01:00:00 | t | |
| GB-Eire | BST | 01:00:00 | t | |
| GMT | GMT | 00:00:00 | f | |
| GMT+0 | GMT | 00:00:00 | f | |
| GMT-0 | GMT | 00:00:00 | f | |
| GMT0 | GMT | 00:00:00 | f | |
| Greenwich | GMT | 00:00:00 | f | |
| Hongkong | HKT | 08:00:00 | f | |
| HST | HST | -10:00:00 | f | |
| Iceland | GMT | 00:00:00 | f | |
| Indian/Antananarivo | EAT | 03:00:00 | f | |
| Indian/Chagos | IOT | 06:00:00 | f | |
| Indian/Christmas | CXT | 07:00:00 | f | |
| Indian/Cocos | CCT | 06:30:00 | f | |
| Indian/Comoro | EAT | 03:00:00 | f | |
| Indian/Kerguelen | TFT | 05:00:00 | f | |
| Indian/Mahe | SCT | 04:00:00 | f | |
| Indian/Maldives | MVT | 05:00:00 | f | |
| Indian/Mauritius | MUT | 04:00:00 | f | |
| Indian/Mayotte | EAT | 03:00:00 | f | |
| Indian/Reunion | RET | 04:00:00 | f | |
| Iran | IRDT | 04:30:00 | t | |
| Israel | IDT | 03:00:00 | t | |
| Jamaica | EST | -05:00:00 | f | |
| Japan | JST | 09:00:00 | f | |
| Kwajalein | MHT | 12:00:00 | f | |
| Libya | EET | 02:00:00 | f | |
| MET | MEST | 02:00:00 | t | |
| Mexico/BajaNorte | PDT | -07:00:00 | t | |
| Mexico/BajaSur | MDT | -06:00:00 | t | |
| Mexico/General | CDT | -05:00:00 | t | |
| MST | MST | -07:00:00 | f | |
| MST7MDT | MDT | -06:00:00 | t | |
| Navajo | MDT | -06:00:00 | t | |
| NZ | NZST | 12:00:00 | f | |
| NZ-CHAT | CHAST | 12:45:00 | f | |
| Pacific/Apia | WST | 13:00:00 | f | |
| Pacific/Auckland | NZST | 12:00:00 | f | |
| Pacific/Chatham | CHAST | 12:45:00 | f | |
| Pacific/Chuuk | CHUT | 10:00:00 | f | |
| Pacific/Easter | EASST | -05:00:00 | t | |
| Pacific/Efate | VUT | 11:00:00 | f | |
| Pacific/Enderbury | PHOT | 13:00:00 | f | |
| Pacific/Fakaofo | TKT | 13:00:00 | f | |
| Pacific/Fiji | FJT | 12:00:00 | f | |
| Pacific/Funafuti | TVT | 12:00:00 | f | |
| Pacific/Galapagos | GALT | -06:00:00 | f | |
| Pacific/Gambier | GAMT | -09:00:00 | f | |
| Pacific/Guadalcanal | SBT | 11:00:00 | f | |
| Pacific/Guam | ChST | 10:00:00 | f | |
| Pacific/Honolulu | HST | -10:00:00 | f | |
| Pacific/Johnston | HST | -10:00:00 | f | |
| Pacific/Kiritimati | LINT | 14:00:00 | f | |
| Pacific/Kosrae | KOST | 11:00:00 | f | |
| Pacific/Kwajalein | MHT | 12:00:00 | f | |
| Pacific/Majuro | MHT | 12:00:00 | f | |
| Pacific/Marquesas | MART | -09:30:00 | f | |
| Pacific/Midway | SST | -11:00:00 | f | |
| Pacific/Nauru | NRT | 12:00:00 | f | |
| Pacific/Niue | NUT | -11:00:00 | f | |
| Pacific/Norfolk | NFT | 11:30:00 | f | |
| Pacific/Noumea | NCT | 11:00:00 | f | |
| Pacific/Pago_Pago | SST | -11:00:00 | f | |
| Pacific/Palau | PWT | 09:00:00 | f | |
| Pacific/Pitcairn | PST | -08:00:00 | f | |
| Pacific/Pohnpei | PONT | 11:00:00 | f | |
| Pacific/Ponape | PONT | 11:00:00 | f | |
| Pacific/Port_Moresby | PGT | 10:00:00 | f | |
| Pacific/Rarotonga | CKT | -10:00:00 | f | |
| Pacific/Saipan | ChST | 10:00:00 | f | |
| Pacific/Samoa | SST | -11:00:00 | f | |
| Pacific/Tahiti | TAHT | -10:00:00 | f | |
| Pacific/Tarawa | GILT | 12:00:00 | f | |
| Pacific/Tongatapu | TOT | 13:00:00 | f | |
| Pacific/Truk | CHUT | 10:00:00 | f | |
| Pacific/Wake | WAKT | 12:00:00 | f | |
| Pacific/Wallis | WFT | 12:00:00 | f | |
| Pacific/Yap | CHUT | 10:00:00 | f | |
| Poland | CEST | 02:00:00 | t | |
| Portugal | WEST | 01:00:00 | t | |
| posixrules | EDT | -04:00:00 | t | |
| PRC | CST | 08:00:00 | f | |
| PST8PDT | PDT | -07:00:00 | t | |
| ROC | CST | 08:00:00 | f | |
| ROK | KST | 09:00:00 | f | |
| Singapore | SGT | 08:00:00 | f | |
| Turkey | EEST | 03:00:00 | t | |
| UCT | UCT | 00:00:00 | f | |
| Universal | UTC | 00:00:00 | f | |
| US/Alaska | AKDT | -08:00:00 | t | |
| US/Aleutian | HADT | -09:00:00 | t | |
| US/Arizona | MST | -07:00:00 | f | |
| US/Central | CDT | -05:00:00 | t | |
| US/East-Indiana | EDT | -04:00:00 | t | |
| US/Eastern | EDT | -04:00:00 | t | |
| US/Hawaii | HST | -10:00:00 | f | |
| US/Indiana-Starke | CDT | -05:00:00 | t | |
| US/Michigan | EDT | -04:00:00 | t | |
| US/Mountain | MDT | -06:00:00 | t | |
| US/Pacific | PDT | -07:00:00 | t | |
| US/Pacific-New | PDT | -07:00:00 | t | |
| US/Samoa | SST | -11:00:00 | f | |
| UTC | UTC | 00:00:00 | f | |
| W-SU | MSK | 04:00:00 | f | |
| WET | WEST | 01:00:00 | t | |
| Zulu | UTC | 00:00:00 | f | |
| (579 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
MySQL 的话可以参考这里
http://www.majormoves.net/post/441/