By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
102 rows affected
Id | Identifier | StandardName | DisplayName | DaylightName | SupportsDaylightSavingTime | BaseUtcOffsetSec | UTC |
---|---|---|---|---|---|---|---|
1 | Dateline Standard Time | Dateline Standard Time | (UTC-12: 00) International Dateline (West) | Dateline Summer Time | False | -43200 | UTC -12:00 |
2 | UTC-11 | UTC-11 | (UTC-11: 00) Coordinated World Time-11 | UTC-11 | False | -39600 | UTC -11:00 |
3 | Hawaiian Standard Time | Hawaii Standard Time | (UTC-10: 00) Hawaii | Hawaii Summer Time | False | -36000 | UTC -10:00 |
4 | Alaskan Standard Time | Alaska Standard Time | (UTC-09: 00) Alaska | Alaska Summer Time | True | -32400 | UTC -09:00 |
5 | Pacific Standard Time (Mexico) | Pacific Standard Time (Mexico) | (UTC-08: 00) Baja California | Pacific Summer Time (Mexico) | True | -28800 | UTC -08:00 |
6 | Pacific Standard Time | Pacific Standard Time | (UTC-08: 00) Pacific Time (USA & Canada) | Pacific Summer Time | True | -28800 | UTC -08:00 |
7 | Us Mountain Standard Time | Mountain Standard Time (Arizona) | (UTC-07: 00) Arizona | Mountain Summer Time (Arizona) | False | -25200 | UTC -07:00 |
8 | Mountain Standard Time (Mexico) | Mountain Standard Time (Mexico) | (UTC-07: 00) Chihuahua, La Paz, Mazatlan | Mountain Summer Time (Mexico) | True | -25200 | UTC -07:00 |
9 | Mountain Standard Time | Mountain Standard Time | (UTC-07: 00) Mountain Time (USA & Canada) | Mountain Summer Time | True | -25200 | UTC -07:00 |
10 | Central Standard Time | Central Standard Time | (UTC-06: 00) Central Time (USA & Canada) | Central Summer Time | True | -21600 | UTC -06:00 |
11 | Central Standard Time (Mexico) | Central Standard Time (Mexico) | (UTC-06: 00) Guadalajara, Mexico City, Monterrey | Central Summer Time (Mexico) | True | -21600 | UTC -06:00 |
12 | Central America Standard Time | Central American Standard Time | (UTC-06: 00) Central America | Central American Summer Time | False | -21600 | UTC -06:00 |
13 | Canada Central Standard Time | Central Standard Time (Canada) | (UTC-06: 00) Saskatchewan | Central Summer Time (Canada) | False | -21600 | UTC -06:00 |
14 | Sa Pacific Standard Time | West. South America Standard Time | (UTC-05: 00) Bogotá, Lima, Quito, Rio Branco | West. South America Summer Time | False | -18000 | UTC -05:00 |
15 | Eastern Standard Time | Eastern Standard Time | (UTC-05: 00) Eastern Time (USA & Canada) | Eastern Summer Time | True | -18000 | UTC -05:00 |
16 | Us Eastern Standard Time | Eastern Standard Time (Indiana) | (UTC-05: 00) Indiana (East) | Eastern Summer Time (Indiana) | True | -18000 | UTC -05:00 |
17 | Venezuela Standard Time | Venezuela Standard Time | (UTC-04: 30) Caracas | Venezuela Summer Time | False | -16200 | UTC -04:30 |
18 | Paraguay Standard Time | Paraguay Standard Time | (UTC-04: 00) Asuncion | Paraguay Summer Time | True | -14400 | UTC -04:00 |
19 | Atlantic Standard Time | Atlantic Standard Time | (UTC-04: 00) Atlantic (Canada) | Atlantic Summer Time | True | -14400 | UTC -04:00 |
20 | Central Brazilian Standard Time | Central Brazilian Standard Time | (UTC-04: 00) Cuiaba | Central Brazilian Summer Time | True | -14400 | UTC -04:00 |
21 | Sa Western Standard Time | Middle South America Standard Time | (UTC-04: 00) Georgetown, La Paz, Manaus, San Juan | Middle South America Summer Time | False | -14400 | UTC -04:00 |
22 | Pacific Sa Standard Time | Chilean Standard Time | (UTC-04: 00) Santiago | Chilean Summer Time | True | -14400 | UTC -04:00 |
23 | Newfoundland Standard Time | Newfoundland Standard Time | (UTC-03: 30) Newfoundland | Newfoundland Summer Time | True | -12600 | UTC -03:30 |
24 | E. South America Standard Time | East South America Standard Time | (UTC-03: 00) Brasilia | Östl. South America Summer Time | True | -10800 | UTC -03:00 |
25 | Argentina Standard Time | Argentina Standard Time | (UTC-03: 00) Buenos Aires | Argentina Summer Time | True | -10800 | UTC -03:00 |
26 | Sa Eastern Standard Time | East South America Standard Time | (UTC-03: 00) Cayenne, Fortaleza | Östl. South America Summer Time | False | -10800 | UTC -03:00 |
27 | Greenland Standard Time | Greenland Standard Time | (UTC-03: 00) Greenland | Greenland Summer Time | True | -10800 | UTC -03:00 |
28 | Montevideo Standard Time | Montevideo Standard Time | (UTC-03: 00) Montevideo | Montevideo Summer Time | True | -10800 | UTC -03:00 |
29 | Bahia Standard Time | Bahia Standard Time | (UTC-03: 00) Salvador | Bahia Summer Time | True | -10800 | UTC -03:00 |
30 | UTC-02 | UTC-02 | (UTC-02: 00) Coordinated Worldtime-02 | UTC-02 | False | -7200 | UTC -02:00 |
31 | Mid-atlantic Standard Time | Central Atlantic Standard Time | (UTC-02: 00) Central Atlantic - Old | Central Atlantic Summer Time | True | -7200 | UTC -02:00 |
32 | Azores Standard Time | Azores Standard Time | (UTC-01: 00) Azores | Azores Summer Time | True | -3600 | UTC -01:00 |
33 | Cape Verde Standard Time | Cape Verde Standard Time | (UTC-01: 00) Cape Verde | Cape Verde Summer Time | False | -3600 | UTC -01:00 |
34 | Morocco Standard Time | Morocco Standard Time | (UTC) Casablanca | Morocco Summer Time | True | 0 | UTC |
35 | Gmt Standard Time | West European Time | (UTC) Dublin, Edinburgh, Lisbon, London | West European Summer Time | True | 0 | UTC |
36 | UTC | Coordinated World Time | (UTC) Coordinated Worldtime | Coordinated World Time | False | 0 | UTC |
37 | Greenwich Standard Time | West African Standard Time | (UTC) Monrovia, Reykjavik | West African Summer Time | False | 0 | UTC |
38 | W. Europe Standard Time | Central European Time | (UTC + 01: 00) Amsterdam, Berlin, Berne, Rome, Stockholm, Vienna | Central European Summer Time | True | 3600 | UTC +01:00 |
39 | Central Europe Standard Time | Central European Time | (UTC + 01: 00) Belgrade, Bratislava (Bratislava), Budapest, Ljubljana, Prague | Central European Summer Time | True | 3600 | UTC +01:00 |
40 | Romance Standard Time | Central European Time | (UTC + 01: 00) Brussels, Copenhagen, Madrid, Paris | Central European Summer Time | True | 3600 | UTC +01:00 |
41 | Central European Standard Time | Central European Time | (UTC + 01: 00) Sarajevo, Skopje, Warsaw, Zagreb | Central European Summer Time | True | 3600 | UTC +01:00 |
42 | W. Central Africa Standard Time | West Central Africa Standard Time | (UTC + 01: 00) West Central Africa | West Central Africa Summer Time | False | 3600 | UTC +01:00 |
43 | Namibia Standard Time | Namibia Standard Time | (UTC + 01: 00) Windhoek | Namibia Summer Time | True | 3600 | UTC +01:00 |
44 | Jordan Standard Time | Jordan Standard Time | (UTC + 02: 00) Amman | Jordan Summer Time | True | 7200 | UTC +02:00 |
45 | Gtb Standard Time | Eastern European Time | (UTC + 02: 00) Athens, Bucharest | Eastern European Summer Time | True | 7200 | UTC +02:00 |
46 | Middle East Standard Time | Middle East Standard Time | (UTC + 02: 00) Beirut | Middle East Summer Time | True | 7200 | UTC +02:00 |
47 | Syria Standard Time | Syria Standard Time | (UTC + 02: 00) Damascus | Syria Summer Time | True | 7200 | UTC +02:00 |
48 | South Africa Standard Time | South Africa Standard Time | (UTC + 02: 00) Harare, Pretoria | South Africa Summer Time | False | 7200 | UTC +02:00 |
49 | Fle Standard Time | Eastern European Time | (UTC + 02: 00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius | Eastern European Summer Time | True | 7200 | UTC +02:00 |
50 | Turkey Standard Time | Turkey Standard Time | (UTC + 02: 00) Istanbul | Turkey Summer Time | True | 7200 | UTC +02:00 |
51 | Israel Standard Time | JerUSAlem Standard Time | (UTC + 02: 00) JerUSAlem | JerUSAlem Summer Time | True | 7200 | UTC +02:00 |
52 | Egypt Standard Time | Egypt Standard Time | (UTC + 02: 00) Cairo | Egypt Summer Time | True | 7200 | UTC +02:00 |
53 | E. Europe Standard Time | Eastern European Time | (UTC + 02: 00) Eastern Europe | Eastern European Summer Time | True | 7200 | UTC +02:00 |
54 | Libya Standard Time | Libya Standard Time | (UTC + 02: 00) Tripoli | Libya Summer Time | True | 7200 | UTC +02:00 |
55 | Arabic Standard Time | Arabic Standard Time | (UTC + 03: 00) Baghdad | Arab Summer Time | True | 10800 | UTC +03:00 |
56 | Kaliningrad Standard Time | Kaliningrad Standard Time | (UTC + 03: 00) Kaliningrad, Minsk | Kaliningrad Summer Time | True | 10800 | UTC +03:00 |
57 | Arab Standard Time | Arabic Standard Time | (UTC + 03: 00) Kuwait, Riyadh | Arab Summer Time | False | 10800 | UTC +03:00 |
58 | E. Africa Standard Time | East African Standard Time | (UTC + 03: 00) Nairobi | East African Summer Time | False | 10800 | UTC +03:00 |
59 | Iran Standard Time | Iran Standard Time | (UTC + 03: 30) Tehran | Iran Summer Time | True | 12600 | UTC +03:30 |
60 | Arabian Standard Time | Arabic Standard Time | (UTC + 04: 00) Abu Dhabi, Muscat | Arab Summer Time | False | 14400 | UTC +04:00 |
61 | Azerbaijan Standard Time | Azerbaijan Standard Time | (UTC + 04: 00) Baku | Azerbaijan Summer Time | True | 14400 | UTC +04:00 |
62 | Caucasus Standard Time | Caucasian Standard Time | (UTC + 04: 00) Yerevan | Caucasian Summer Time | True | 14400 | UTC +04:00 |
63 | Russian Standard Time | Russian Standard Time | (UTC + 04: 00) Moscow, St. Petersburg, Volgograd | Russian Summer Time | True | 14400 | UTC +04:00 |
64 | Mauritius Standard Time | Mauritius Standard Time | (UTC + 04: 00) Port Louis | Mauritius Summer Time | True | 14400 | UTC +04:00 |
65 | Georgian Standard Time | Georgian Standard Time | (UTC + 04: 00) Tbilisi | Georgian Summer Time | False | 14400 | UTC +04:00 |
66 | Afghanistan Standard Time | Afghanistan Standard Time | (UTC + 04: 30) Kabul | Afghanistan Summer Time | False | 16200 | UTC +04:30 |
67 | West Asia Standard Time | West Asia Standard Time | (UTC + 05: 00) Ashgabat, Tashkent | West Asia Summer Time | False | 18000 | UTC +05:00 |
68 | Pakistan Standard Time | Pakistan Standard Time | (UTC + 05: 00) Islamabad, Karachi | Pakistan Summer Time | True | 18000 | UTC +05:00 |
69 | India Standard Time | India Standard Time | (UTC + 05: 30) Chennai, Kolkata, Mumbai, New Delhi | India Summer Time | False | 19800 | UTC +05:30 |
70 | Sri Lanka Standard Time | Sri Lanka Standard Time | (UTC + 05: 30) Sri Jayawardenepura | Sri Lanka Summer Time | False | 19800 | UTC +05:30 |
71 | Nepal Standard Time | Nepal Standard Time | (UTC + 05: 45) Kathmandu | Nepal Summer Time | False | 20700 | UTC +05:45 |
72 | Central Asia Standard Time | Central Asia Standard Time | (UTC + 06: 00) Astana | Central Asia Summer Time | False | 21600 | UTC +06:00 |
73 | Bangladesh Standard Time | Bangladesh Standard Time | (UTC + 06: 00) Dakka | Bangladesh Summer Time | True | 21600 | UTC +06:00 |
74 | Ekaterinburg Standard Time | Yekaterinburg Standard Time | (UTC + 06: 00) Yekaterinburg | Yekaterinburg Summer Time | True | 21600 | UTC +06:00 |
75 | Myanmar Standard Time | Myanmar Standard Time | (UTC + 06: 30) Yangon (Yangon) | Myanmar Summer Time | False | 23400 | UTC +06:30 |
76 | Se Asia Standard Time | SouthEast Asian Standard Time | (UTC + 07: 00) Bangkok, Hanoi, Jakarta | SouthEast Asian Summer Time | False | 25200 | UTC +07:00 |
77 | N. Central Asia Standard Time | North Central Asia Standard Time | (UTC + 07: 00) Novosibirsk | North Central Asia Summer Time | True | 25200 | UTC +07:00 |
78 | North Asia Standard Time | North Asia Standard Time | (UTC + 08: 00) Krasnoyarsk | North Asia Summer Time | True | 28800 | UTC +08:00 |
79 | Singapore Standard Time | Malay Peninsula Standard Time | (UTC + 08: 00) Kuala Lumpur, Singapore | Malay Peninsula Summer Time | False | 28800 | UTC +08:00 |
80 | China Standard Time | China Standard Time | (UTC + 08: 00) Beijing, Chongqing, Hong Kong (Sar), Urumchi | China Summer Time | False | 28800 | UTC +08:00 |
81 | W. Australia Standard Time | Western Australian Standard Time | (UTC + 08: 00) Perth | Western Australian Summer Time | True | 28800 | UTC +08:00 |
82 | Taipei Standard Time | Taipei Standard Time | (UTC + 08: 00) Taipei | Taipei Summer Time | False | 28800 | UTC +08:00 |
83 | Ulaanbaatar Standard Time | Ulan-bator Standard Time | (UTC + 08: 00) Ulan-bator | Ulan-bator Summer Time | False | 28800 | UTC +08:00 |
84 | North Asia East Standard Time | East-north Asian Standard Time | (UTC + 09: 00) Irkutsk | East-north Asian Summer Time | True | 32400 | UTC +09:00 |
85 | Tokyo Standard Time | Japanese Standard Time | (UTC + 09: 00) Osaka, Sapporo, Tokyo | Japanese Summer Time | False | 32400 | UTC +09:00 |
86 | Korea Standard Time | Korean Standard Time | (UTC + 09: 00) Seoul | Korean Summer Time | False | 32400 | UTC +09:00 |
87 | Cen. Australia Standard Time | Central Australian Standard Time | (UTC + 09: 30) Adelaide | Central Australian Summer Time | True | 34200 | UTC +09:30 |
88 | Aus Central Standard Time | Central Australian Standard Time | (UTC + 09: 30) Darwin | Central Australian Summer Time | False | 34200 | UTC +09:30 |
89 | E. Australia Standard Time | Eastern Australian Standard Time | (UTC + 10: 00) Brisbane | Ostaustralische Sommertime | False | 36000 | UTC +10:00 |
90 | Aus Eastern Standard Time | Eastern Australian Standard Time | (UTC + 10: 00) Canberra, Melbourne, Sydney | Ostaustralische Sommertime | True | 36000 | UTC +10:00 |
91 | West Pacific Standard Time | Western Pacific Standard Time | (UTC + 10: 00) Guam, Port Moresby | Western Pacific Summer Time | False | 36000 | UTC +10:00 |
92 | Tasmania Standard Time | Tasmania Standard Time | (UTC + 10: 00) Hobart | Tasmania Summer Time | True | 36000 | UTC +10:00 |
93 | Yakutsk Standard Time | Yakutsk Standard Time | (UTC + 10: 00) Yakutsk | Yakutsk Summer Time | True | 36000 | UTC +10:00 |
94 | Central Pacific Standard Time | Central Pacific Standard Time | (UTC + 11: 00) Solomon Islands, New Caledonia | Central Pacific Summer Time | False | 39600 | UTC +11:00 |
95 | Vladivostok Standard Time | Vladivostok Standard Time | (UTC + 11: 00) Vladivostok | Vladivostok Summer Time | True | 39600 | UTC +11:00 |
96 | New Zealand Standard Time | New Zealand Standard Time | (UTC + 12: 00) Auckland, Wellington | New Zealand Summer Time | True | 43200 | UTC +12:00 |
97 | Fiji Standard Time | Fiji Standard Time | (UTC + 12: 00) Fiji | Fiji Summer Time | True | 43200 | UTC +12:00 |
98 | UTC+12 | UTC + 12 | (UTC + 12: 00) Coordinated Worldtime + 12 | UTC + 12 | False | 43200 | UTC +12:00 |
99 | Magadan Standard Time | Magadan Standard Time | (UTC + 12: 00) Magadan | Magadan Summer Time | True | 43200 | UTC +12:00 |
100 | Kamchatka Standard Time | Kamchatka Standard Time | (UTC + 12: 00) Petropavlovsk-kamchatsky - Outdated | Kamchatka Summer Time | True | 43200 | UTC +12:00 |
101 | Tonga Standard Time | Tonga Standard Time | (UTC + 13: 00) Nuku'alofa | Tonga Summer Time | False | 46800 | UTC +13:00 |
102 | Samoa Standard Time | Samoa Standard Time | (UTC + 13: 00) Samoa | Samoa Summer Time | True | 46800 | UTC +13:00 |
identifier |
---|
Pacific Standard Time (Mexico) |