add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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)