nodesocket/gist:3919205

alketii · 2016-09-27T11:26:29Z

If someone needs it as sql

DROP TABLE IF EXISTS `timezones`;
CREATE TABLE `timezones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `timezones` (`id`, `value`, `label`) VALUES
(1, '-12:00',   '(GMT -12:00) Eniwetok, Kwajalein'),
(2, '-11:00',   '(GMT -11:00) Midway Island, Samoa'),
(3, '-10:00',   '(GMT -10:00) Hawaii'),
(4, '-09:50',   '(GMT -9:30) Taiohae'),
(5, '-09:00',   '(GMT -9:00) Alaska'),
(6, '-08:00',   '(GMT -8:00) Pacific Time (US &amp; Canada)'),
(7, '-07:00',   '(GMT -7:00) Mountain Time (US &amp; Canada)'),
(8, '-06:00',   '(GMT -6:00) Central Time (US &amp; Canada), Mexico City'),
(9, '-05:00',   '(GMT -5:00) Eastern Time (US &amp; Canada), Bogota, Lima'),
(10,    '-04:50',   '(GMT -4:30) Caracas'),
(11,    '-04:00',   '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz'),
(12,    '-03:50',   '(GMT -3:30) Newfoundland'),
(13,    '-03:00',   '(GMT -3:00) Brazil, Buenos Aires, Georgetown'),
(14,    '-02:00',   '(GMT -2:00) Mid-Atlantic'),
(15,    '-01:00',   '(GMT -1:00) Azores, Cape Verde Islands'),
(16,    '+00:00',   '(GMT) Western Europe Time, London, Lisbon, Casablanca'),
(17,    '+01:00',   '(GMT +1:00) Brussels, Copenhagen, Madrid, Paris'),
(18,    '+02:00',   '(GMT +2:00) Kaliningrad, South Africa'),
(19,    '+03:00',   '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg'),
(20,    '+03:50',   '(GMT +3:30) Tehran'),
(21,    '+04:00',   '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi'),
(22,    '+04:50',   '(GMT +4:30) Kabul'),
(23,    '+05:00',   '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent'),
(24,    '+05:50',   '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi'),
(25,    '+05:75',   '(GMT +5:45) Kathmandu, Pokhar'),
(26,    '+06:00',   '(GMT +6:00) Almaty, Dhaka, Colombo'),
(27,    '+06:50',   '(GMT +6:30) Yangon, Mandalay'),
(28,    '+07:00',   '(GMT +7:00) Bangkok, Hanoi, Jakarta'),
(29,    '+08:00',   '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong'),
(30,    '+08:75',   '(GMT +8:45) Eucla'),
(31,    '+09:00',   '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk'),
(32,    '+09:50',   '(GMT +9:30) Adelaide, Darwin'),
(33,    '+10:00',   '(GMT +10:00) Eastern Australia, Guam, Vladivostok'),
(34,    '+10:50',   '(GMT +10:30) Lord Howe Island'),
(35,    '+11:00',   '(GMT +11:00) Magadan, Solomon Islands, New Caledonia'),
(36,    '+11:50',   '(GMT +11:30) Norfolk Island'),
(37,    '+12:00',   '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka'),
(38,    '+12:75',   '(GMT +12:45) Chatham Islands'),
(39,    '+13:00',   '(GMT +13:00) Apia, Nukualofa'),
(40,    '+14:00',   '(GMT +14:00) Line Islands, Tokelau');

goatandsheep · 2017-07-20T21:58:09Z

{type: Array,  
            value: [
                { name: "(GMT -12:00) Eniwetok, Kwajalein", value: "-12:00"},
                { name: "(GMT -11:00) Midway Island, Samoa", value: "-11:00"},
                { name: "(GMT -10:00) Hawaii", value: "-10:00"},
                { name: "(GMT -9:30) Taiohae", value: "-09:50"},
                { name: "(GMT -9:00) Alaska", value: "-09:00"},
                { name: "(GMT -8:00) Pacific Time (US &amp; Canada)", value: "-08:00"},
                { name: "(GMT -7:00) Mountain Time (US &amp; Canada)", value: "-07:00"},
                { name: "(GMT -6:00) Central Time (US &amp; Canada), Mexico City", value: "-06:00"},
                { name: "(GMT -5:00) Eastern Time (US &amp; Canada), Bogota, Lima", value: "-05:00"},
                { name: "(GMT -4:30) Caracas", value: "-04:50"},
                { name: "(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz", value: "-04:00"},
                { name: "(GMT -3:30) Newfoundland", value: "-03:50"},
                { name: "(GMT -3:00) Brazil, Buenos Aires, Georgetown", value: "-03:00"},
                { name: "(GMT -2:00) Mid-Atlantic", value: "-02:00"},
                { name: "(GMT -1:00) Azores, Cape Verde Islands", value: "-01:00", selected="selected"},
                { name: "(GMT) Western Europe Time, London, Lisbon, Casablanca", value: "+00:00"},
                { name: "(GMT +1:00) Brussels, Copenhagen, Madrid, Paris", value: "+01:00"},
                { name: "(GMT +2:00) Kaliningrad, South Africa", value: "+02:00"},
                { name: "(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg", value: "+03:00"},
                { name: "(GMT +3:30) Tehran", value: "+03:50"},
                { name: "(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi", value: "+04:00"},
                { name: "(GMT +4:30) Kabul", value: "+04:50"},
                { name: "(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent", value: "+05:00"},
                { name: "(GMT +5:30) Bombay, Calcutta, Madras, New Delhi", value: "+05:50"},
                { name: "(GMT +5:45) Kathmandu, Pokhara", value: "+05:75"},
                { name: "(GMT +6:00) Almaty, Dhaka, Colombo", value: "+06:00"},
                { name: "(GMT +6:30) Yangon, Mandalay", value: "+06:50"},
                { name: "(GMT +7:00) Bangkok, Hanoi, Jakarta", value: "+07:00"},
                { name: "(GMT +8:00) Beijing, Perth, Singapore, Hong Kong", value: "+08:00"},
                { name: "(GMT +8:45) Eucla", value: "+08:75"},
                { name: "(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk", value: "+09:00"},
                { name: "(GMT +9:30) Adelaide, Darwin", value: "+09:50"},
                { name: "(GMT +10:00) Eastern Australia, Guam, Vladivostok", value: "+10:00"},
                { name: "(GMT +10:30) Lord Howe Island", value: "+10:50"},
                { name: "(GMT +11:00) Magadan, Solomon Islands, New Caledonia", value: "+11:00"},
                { name: "(GMT +11:30) Norfolk Island", value: "+11:50"},
                { name: "(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka", value: "+12:00"},
                { name: "(GMT +12:45) Chatham Islands", value: "+12:75"},
                { name: "(GMT +13:00) Apia, Nukualofa", value: "+13:00"},
                { name: "(GMT +14:00) Line Islands, Tokelau", value: "+14:00"}
            ]
        }

mattjohnsonpint · 2017-08-30T05:48:43Z

Lists like these are dangerous.

They assume a time zone can be represented by a single numeric offset, which is incorrect.
They overlook that even time zones that share the same offset or set of offsets may use different transitions between standard time and daylight time (where applicable).
They often assume there is only one time zone that uses a particular offset, which is usually false.
They often are opinionated, omitting time zones that an individual didn't think were important.
They are rarely updated to reflect changes to time zones as they occur over the world.
The are often copied poorly from more reliable sources.

The only reliable sources of time zone information are:

The IANA time zone database, when the system is kept updated
The Microsoft Windows time zone database, from the June 2016 update forward, when the system is kept updated
Languages, platforms, libraries and APIs that derive from their data from the above two sources, when kept updated.

I am writing this here because this gist is referenced from several pages on the Internet that appear to be taking these lists as reliable sources of truth. They are in fact - not.

jesraygarciano · 2018-02-08T03:34:45Z

Thanks

cccaldas · 2018-07-04T15:05:58Z

+1

ernestbangbuh · 2019-02-01T15:42:48Z

Hi i have a table with many columns like cities, countries zip codes and others, i need to add a new column in an ssis package such that when i run the packed a new column called timezone automatically populates with the various times against the countries and cities. How do i achieve this??

roymoran · 2019-06-21T15:08:13Z

Appreciate your input here @mj1856.

soubhikchatterjee · 2019-07-03T09:56:58Z

I am using a nodejs/mysql project and wish to use this list, can someone please tell me if its more efficient (in terms of faster loading) of this complete list to load from a file or a mysql db?

isat7 · 2019-09-24T11:37:23Z

thank you

kamleshwebtech · 2020-02-22T14:50:34Z

<?php 
$america_timezones_list = array(
		'+00:00' => '(+00:00) Danmarkshavn',
		'-01:00' => '(-01:00) Scoresbysund',
		'-02:00' => '(-02:00) Noronha',
		'-03:00' => '(-03:00) Montevideo',
		'-03:00' => '(-03:00) Cayenne',
		'-03:00' => '(-03:00) Paramaribo',
		'-03:00' => '(-03:00) Miquelon',
		'-03:00' => '(-03:00) Araguaina',
		'-03:00' => '(-03:00) Santiago',
		'-03:00' => '(-03:00) Punta Arenas',
		'-03:00' => '(-03:00) Argentina/Buenos Aires',
		'-03:00' => '(-03:00) Argentina/Catamarca',
		'-03:00' => '(-03:00) Argentina/Mendoza',
		'-03:00' => '(-03:00) Argentina/San Luis',
		'-03:00' => '(-03:00) Argentina/San Juan',
		'-03:00' => '(-03:00) Argentina/La Rioja',
		'-03:00' => '(-03:00) Sao Paulo',
		'-03:00' => '(-03:00) Asuncion',
		'-03:00' => '(-03:00) Godthab',
		'-03:00' => '(-03:00) Bahia',
		'-03:00' => '(-03:00) Argentina/Rio Gallegos',
		'-03:00' => '(-03:00) Argentina/Jujuy',
		'-03:00' => '(-03:00) Argentina/Tucuman',
		'-03:00' => '(-03:00) Belem',
		'-03:00' => '(-03:00) Recife',
		'-03:00' => '(-03:00) Fortaleza',
		'-03:00' => '(-03:00) Santarem',
		'-03:00' => '(-03:00) Argentina/Cordoba',
		'-03:00' => '(-03:00) Maceio',
		'-03:00' => '(-03:00) Argentina/Salta',
		'-03:00' => '(-03:00) Argentina/Ushuaia',
		'-03:30' => '(-03:30) St Johns',
		'-04:00' => '(-04:00) St Barthelemy',
		'-04:00' => '(-04:00) Port of Spain',
		'-04:00' => '(-04:00) Santo Domingo',
		'-04:00' => '(-04:00) Anguilla',
		'-04:00' => '(-04:00) Tortola',
		'-04:00' => '(-04:00) Thule',
		'-04:00' => '(-04:00) Puerto Rico',
		'-04:00' => '(-04:00) Barbados',
		'-04:00' => '(-04:00) Porto Velho',
		'-04:00' => '(-04:00) Moncton',
		'-04:00' => '(-04:00) Martinique',
		'-04:00' => '(-04:00) La Paz',
		'-04:00' => '(-04:00) Cuiaba',
		'-04:00' => '(-04:00) Antigua',
		'-04:00' => '(-04:00) St Vincent',
		'-04:00' => '(-04:00) Montserrat',
		'-04:00' => '(-04:00) Boa Vista',
		'-04:00' => '(-04:00) Marigot',
		'-04:00' => '(-04:00) Manaus',
		'-04:00' => '(-04:00) Kralendijk',
		'-04:00' => '(-04:00) Goose Bay',
		'-04:00' => '(-04:00) Dominica',
		'-04:00' => '(-04:00) Campo Grande',
		'-04:00' => '(-04:00) Lower Princes',
		'-04:00' => '(-04:00) St Thomas',
		'-04:00' => '(-04:00) Halifax',
		'-04:00' => '(-04:00) St Lucia',
		'-04:00' => '(-04:00) Caracas',
		'-04:00' => '(-04:00) Guyana',
		'-04:00' => '(-04:00) St Kitts',
		'-04:00' => '(-04:00) Curacao',
		'-04:00' => '(-04:00) Aruba',
		'-04:00' => '(-04:00) Blanc-Sablon',
		'-04:00' => '(-04:00) Glace Bay',
		'-04:00' => '(-04:00) Grenada',
		'-04:00' => '(-04:00) Guadeloupe',
		'-05:00' => '(-05:00) Indiana/Marengo',
		'-05:00' => '(-05:00) Indiana/Indianapolis',
		'-05:00' => '(-05:00) Havana',
		'-05:00' => '(-05:00) New York',
		'-05:00' => '(-05:00) Indiana/Vincennes',
		'-05:00' => '(-05:00) Jamaica',
		'-05:00' => '(-05:00) Port-au-Prince',
		'-05:00' => '(-05:00) Panama',
		'-05:00' => '(-05:00) Nassau',
		'-05:00' => '(-05:00) Thunder Bay',
		'-05:00' => '(-05:00) Kentucky/Monticello',
		'-05:00' => '(-05:00) Kentucky/Louisville',
		'-05:00' => '(-05:00) Lima',
		'-05:00' => '(-05:00) Atikokan',
		'-05:00' => '(-05:00) Cancun',
		'-05:00' => '(-05:00) Cayman',
		'-05:00' => '(-05:00) Bogota',
		'-05:00' => '(-05:00) Iqaluit',
		'-05:00' => '(-05:00) Nipigon',
		'-05:00' => '(-05:00) Pangnirtung',
		'-05:00' => '(-05:00) Indiana/Vevay',
		'-05:00' => '(-05:00) Indiana/Winamac',
		'-05:00' => '(-05:00) Indiana/Petersburg',
		'-05:00' => '(-05:00) Guayaquil',
		'-05:00' => '(-05:00) Grand Turk',
		'-05:00' => '(-05:00) Detroit',
		'-05:00' => '(-05:00) Eirunepe',
		'-05:00' => '(-05:00) Rio Branco',
		'-05:00' => '(-05:00) Toronto',
		'-06:00' => '(-06:00) Belize',
		'-06:00' => '(-06:00) Indiana/Tell City',
		'-06:00' => '(-06:00) Chicago',
		'-06:00' => '(-06:00) Merida',
		'-06:00' => '(-06:00) Managua',
		'-06:00' => '(-06:00) Menominee',
		'-06:00' => '(-06:00) Rankin Inlet',
		'-06:00' => '(-06:00) Tegucigalpa',
		'-06:00' => '(-06:00) Mexico City',
		'-06:00' => '(-06:00) North Dakota/Center',
		'-06:00' => '(-06:00) Rainy River',
		'-06:00' => '(-06:00) Resolute',
		'-06:00' => '(-06:00) Indiana/Knox',
		'-06:00' => '(-06:00) El Salvador',
		'-06:00' => '(-06:00) Costa Rica',
		'-06:00' => '(-06:00) Matamoros',
		'-06:00' => '(-06:00) Winnipeg',
		'-06:00' => '(-06:00) Bahia Banderas',
		'-06:00' => '(-06:00) Regina',
		'-06:00' => '(-06:00) North Dakota/Beulah',
		'-06:00' => '(-06:00) Swift Current',
		'-06:00' => '(-06:00) Guatemala',
		'-06:00' => '(-06:00) North Dakota/New Salem',
		'-06:00' => '(-06:00) Monterrey',
		'-07:00' => '(-07:00) Mazatlan',
		'-07:00' => '(-07:00) Ojinaga',
		'-07:00' => '(-07:00) Chihuahua',
		'-07:00' => '(-07:00) Denver',
		'-07:00' => '(-07:00) Phoenix',
		'-07:00' => '(-07:00) Hermosillo',
		'-07:00' => '(-07:00) Creston',
		'-07:00' => '(-07:00) Yellowknife',
		'-07:00' => '(-07:00) Inuvik',
		'-07:00' => '(-07:00) Edmonton',
		'-07:00' => '(-07:00) Dawson Creek',
		'-07:00' => '(-07:00) Cambridge Bay',
		'-07:00' => '(-07:00) Fort Nelson',
		'-07:00' => '(-07:00) Boise',
		'-08:00' => '(-08:00) Los Angeles',
		'-08:00' => '(-08:00) Vancouver',
		'-08:00' => '(-08:00) Tijuana',
		'-08:00' => '(-08:00) Dawson',
		'-08:00' => '(-08:00) Whitehorse',
		'-09:00' => '(-09:00) Yakutat',
		'-09:00' => '(-09:00) Juneau',
		'-09:00' => '(-09:00) Nome',
		'-09:00' => '(-09:00) Anchorage',
		'-09:00' => '(-09:00) Sitka',
		'-09:00' => '(-09:00) Metlakatla',
		'-10:00' => '(-10:00) Adak'
	);

hkarakose · 2020-03-18T09:51:35Z

Date/time APIs do not support daylight savings changes if you use timezones in GMT or UTC format.

Instead you should use timezones which provide location information. For example, you should use "Asia/Istanbul" instead of GMT+2

irynazaiets · 2020-04-17T13:49:52Z

Where is Kyiv - the capital of Ukraine?

prasadrajuv · 2020-09-26T17:16:34Z

(GMT +5:30) Bombay, Calcutta, Madras ------ 05:30 instead of +05:50

VIRGO96 · 2020-12-19T08:27:44Z

Thank you So much

epursimuove · 2020-12-30T19:37:31Z

Please listen to @mj1856 saying "Lists like these are dangerous". You will soon have errors in your code, if using these hardcoded lists.

ericol · 2021-11-16T16:28:06Z

@kamleshwebtech you don't PHP much, do you?

var_export($america_timezones_list);

RESULT:

array (
  '+00:00' => '(+00:00) Danmarkshavn',
  '-01:00' => '(-01:00) Scoresbysund',
  '-02:00' => '(-02:00) Noronha',
  '-03:00' => '(-03:00) Argentina/Ushuaia',
  '-03:30' => '(-03:30) St Johns',
  '-04:00' => '(-04:00) Guadeloupe',
  '-05:00' => '(-05:00) Toronto',
  '-06:00' => '(-06:00) Monterrey',
  '-07:00' => '(-07:00) Boise',
  '-08:00' => '(-08:00) Whitehorse',
  '-09:00' => '(-09:00) Metlakatla',
  '-10:00' => '(-10:00) Adak',
)

You'd probably be better off by switching keys and values.

aftabkhaliq · 2021-12-08T07:03:50Z

Laravel seeder for time Zones

class TimeZoneSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
if (TimeZone::all()->count() > 0) return;

    TimeZone::insert([

        ['id'=>1,'value'=>'-12:00', 'name'=>'(GMT -12:00) Eniwetok Kwajalein'],
        ['id'=>2, 'value'=>'-11:00', 'name'=>'(GMT -11:00) Midway Island, Samoa'],
        ['id'=>3, 'value'=>'-10:00', 'name'=>'(GMT -10:00) Hawaii'],
        ['id'=>4, 'value'=>'-09:50', 'name'=>'(GMT -9:30) Taiohae'],
        ['id'=>5, 'value'=>'-09:00', 'name'=>'(GMT -9:00) Alaska'],
        ['id'=>6, 'value'=>'-08:00', 'name'=>'(GMT -8:00) Pacific Time [US &amp; Canada)'],
        ['id'=>7, 'value'=>'-07:00', 'name'=>'(GMT -7:00) Mountain Time [US &amp; Canada)'],
        ['id'=>8, 'value'=>'-06:00', 'name'=>'(GMT -6:00) Central Time [US &amp; Canada], Mexico City'],
        ['id'=>9, 'value'=>'-05:00', 'name'=>'(GMT -5:00) Eastern Time [US &amp; Canada], Bogota, Lima'],
        ['id'=>10, 'value'=>'-04:50', 'name'=>'(GMT -4:30) Caracas'],
        ['id'=>11, 'value'=>'-04:00', 'name'=>'(GMT -4:00) Atlantic Time [Canada], Caracas, La Paz'],
        ['id'=>12, 'value'=>'-03:50', 'name'=>'(GMT -3:30) Newfoundland'],
        ['id'=>13, 'value'=>'-03:00', 'name'=>'(GMT -3:00) Brazil, Buenos Aires, Georgetown'],
        ['id'=>14, 'value'=>'-02:00', 'name'=>'(GMT -2:00) Mid-Atlantic'],
        ['id'=>15, 'value'=>'-01:00', 'name'=>'(GMT -1:00) Azores, Cape Verde Islands'],
        ['id'=>16, 'value'=>'+00:00', 'name'=>'(GMT) Western Europe Time, London, Lisbon, Casablanca'],
        ['id'=>17, 'value'=>'+01:00', 'name'=>'(GMT +1:00) Brussels, Copenhagen, Madrid, Paris'],
        ['id'=>18, 'value'=>'+02:00', 'name'=>'(GMT +2:00) Kaliningrad, South Africa'],
        ['id'=>19, 'value'=>'+03:00', 'name'=>'(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg'],
        ['id'=>20, 'value'=>'+03:50', 'name'=>'(GMT +3:30) Tehran'],
        ['id'=>21, 'value'=>'+04:00', 'name'=>'(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi'],
        ['id'=>22, 'value'=>'+04:50', 'name'=>'(GMT +4:30) Kabul'],
        ['id'=>23, 'value'=>'+05:00', 'name'=>'(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent'],
        ['id'=>24, 'value'=>'+05:50', 'name'=>'(GMT +5:30) Bombay, Calcutta, Madras, New Delhi'],
        ['id'=>25, 'value'=>'+05:75', 'name'=>'(GMT +5:45) Kathmandu, Pokhar'],
        ['id'=>26, 'value'=>'+06:00', 'name'=>'(GMT +6:00) Almaty, Dhaka, Colombo'],
        ['id'=>27, 'value'=>'+06:50', 'name'=>'(GMT +6:30) Yangon, Mandalay'],
        ['id'=>28, 'value'=>'+07:00', 'name'=>'(GMT +7:00) Bangkok, Hanoi, Jakarta'],
        ['id'=>29, 'value'=>'+08:00', 'name'=>'(GMT +8:00) Beijing, Perth, Singapore, Hong Kong'],
        ['id'=>30, 'value'=>'+08:75', 'name'=>'(GMT +8:45) Eucla'],
        ['id'=>31, 'value'=>'+09:00', 'name'=>'(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk'],
        ['id'=>32, 'value'=>'+09:50', 'name'=>'(GMT +9:30) Adelaide, Darwin'],
        ['id'=>33, 'value'=>'+10:00', 'name'=>'(GMT +10:00) Eastern Australia, Guam, Vladivostok'],
        ['id'=>34, 'value'=>'+10:50', 'name'=>'(GMT +10:30) Lord Howe Island'],
        ['id'=>35, 'value'=>'+11:00', 'name'=>'(GMT +11:00) Magadan, Solomon Islands, New Caledonia'],
        ['id'=>36, 'value'=>'+11:50', 'name'=>'(GMT +11:30) Norfolk Island'],
        ['id'=>37, 'value'=>'+12:00', 'name'=>'(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka'],
        ['id'=>38, 'value'=>'+12:75', 'name'=>'(GMT +12:45) Chatham Islands'],
        ['id'=>39, 'value'=>'+13:00', 'name'=>'(GMT +13:00) Apia, Nukualofa'],
        ['id'=>40, 'value'=>'+14:00', 'name'=>'(GMT +14:00) Line Islands, Tokelau'],
    ]);
}

}

mattjohnsonpint · 2021-12-08T14:58:08Z

@nodesocket - please delete this gist. It's encouraging a lot of bad implementations. See my previous comments above. Thanks.

mcgingras · 2022-02-03T16:23:44Z

I found this list extremely valuable thanks please do not delete

tranchausky · 2023-03-03T14:39:14Z

php code :D

define('TIME_ZONE', [
    '-12:00' => '(GMT -12:00) Eniwetok, Kwajalein',
    '-11:00' => '(GMT -11:00) Midway Island, Samoa',
    '-10:00' => '(GMT -10:00) Hawaii',
    '-09:30' => '(GMT -9:30) Taiohae',
    '-09:00' => '(GMT -9:00) Alaska',
    '-08:00' => '(GMT -8:00) Pacific Time (US & Canada)',
    '-07:00' => '(GMT -7:00) Mountain Time (US & Canada)',
    '-06:00' => '(GMT -6:00) Central Time (US & Canada), Mexico City',
    '-05:00' => '(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima',
    '-04:30' => '(GMT -4:30) Caracas',
    '-04:00' => '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz',
    '-03:30' => '(GMT -3:30) Newfoundland',
    '-03:00' => '(GMT -3:00) Brazil, Buenos Aires, Georgetown',
    '-02:00' => '(GMT -2:00) Mid-Atlantic',
    '-01:00' => '(GMT -1:00) Azores, Cape Verde Islands',
    '+00:00' => '(GMT) Western Europe Time, London, Lisbon, Casablanca',
    '+01:00' => '(GMT +1:00) Brussels, Copenhagen, Madrid, Paris',
    '+02:00' => '(GMT +2:00) Kaliningrad, South Africa',
    '+03:00' => '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg',
    '+03:30' => '(GMT +3:30) Tehran',
    '+04:00' => '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi',
    '+04:30' => '(GMT +4:30) Kabul',
    '+05:00' => '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent',
    '+05:30' => '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi',
    '+05:45' => '(GMT +5:45) Kathmandu, Pokhara',
    '+06:00' => '(GMT +6:00) Almaty, Dhaka, Colombo',
    '+06:30' => '(GMT +6:30) Yangon, Mandalay',
    '+07:00' => '(GMT +7:00) Bangkok, Hanoi, Jakarta',
    '+08:00' => '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong',
    '+08:45' => '(GMT +8:45) Eucla',
    '+09:00' => '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk',
    '+09:30' => '(GMT +9:30) Adelaide, Darwin',
    '+10:00' => '(GMT +10:00) Eastern Australia, Guam, Vladivostok',
    '+10:30' => '(GMT +10:30) Lord Howe Island',
    '+11:00' => '(GMT +11:00) Magadan, Solomon Islands, New Caledonia',
    '+11:30' => '(GMT +11:30) Norfolk Island',
    '+12:00' => '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka',
    '+12:45' => '(GMT +12:45) Chatham Islands',
    '+13:00' => '(GMT +13:00) Apia, Nukualofa',
    '+14:00' => '(GMT +14:00) Line Islands, Tokelau',
]);

Simvolick · 2023-03-11T08:48:34Z

This is extremely appreciated.

epursimuove · 2023-05-19T09:54:18Z

Warning! Please, do not use lists like this when trying to work correctly with time zones.

This is not a list of "All world timezones". It is not a complete list. It is not even time zones, just random values that may look like time zones, but are so far away from real time zones. Time zones can not be simplified to hardcoded lists like this.

Using lists similar to this for representing time zones will always fail.

Please read the important points in the comment from mattjohnsonpint (from 2017).

dorogoff · 2023-09-13T21:08:17Z

Yeah, @epursimuove is right, because eg (GMT -5:00) Eastern Time (US & Canada), Bogota, Lima is not true,
because Eastern Time in common has daylight saving time EST/EDT, but Bogota and Lima doesn't observe daylight time

vreemt · 2024-04-25T12:18:22Z

echoing the "this list is wrong" comments
I'm in the UK, and we're not on GMT at the moment, GMT is 12:15 and it's currently 13:15, or BST, or UTC+1, or GMT+1 here. Daylight savings time in the UK started on the same date as "Most European countries", 31 March 2024.

As another example of why not to use a hardcoded or a simplified list...

Amsterdam is currently using CEST, or Central European Summer Time, or UTC+2 (Daylight savings started there on 31 March 2024). Right now, it the same time in Amsterdam, The Netherlands as in Harare, Zimbabwe, which currently observes Central Africa Time (CAT) all year. IST (Israel Standard Time) is also UTC+2, but not currently observed, because Israel is on Daylight Savings time (UTC+3, which started on 29 March 2024). Not to be confused with IST – Irish Standard Time (UTC+1) or IST – Indian Standard Time (UTC+5:30). Also note a lot of these place names aren't in the lists above (Amsterdam, Harare, Zimbabwe, Israel, Ireland, India).

if you're looking for actual timezones, try https://en.wikipedia.org/wiki/List_of_tz_database_time_zones which is based on the IANA standards

and for a shorter, more textual version https://www.timeanddate.com/time/current-number-time-zones.html (there's 38 for today, 25 April 2024)

I'm currently making a spreadsheet to help me get a time zone list for use with a summer events form, using different resources, and starting at the top (UTC +14), I've already found the following

Short	description	notes
TOST	Tonga daylight savings (UTC +14)	no longer in use since 2019
LINT UTC-10	Pacific Line Islands	UTC +14 in use since 1994
NZDT	New Zealand Daylight Time (UTC +13)	used in NZ and Antarctica summers, from 29 Sep 2024. from Apr-Sep use NZST (UTC +12)

	<select name="timezone_offset" id="timezone-offset" class="span5">
	<option value="-12:00">(GMT -12:00) Eniwetok, Kwajalein</option>
	<option value="-11:00">(GMT -11:00) Midway Island, Samoa</option>
	<option value="-10:00">(GMT -10:00) Hawaii</option>
	<option value="-09:50">(GMT -9:30) Taiohae</option>
	<option value="-09:00">(GMT -9:00) Alaska</option>
	<option value="-08:00">(GMT -8:00) Pacific Time (US & Canada)</option>
	<option value="-07:00">(GMT -7:00) Mountain Time (US & Canada)</option>
	<option value="-06:00">(GMT -6:00) Central Time (US & Canada), Mexico City</option>
	<option value="-05:00">(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima</option>
	<option value="-04:50">(GMT -4:30) Caracas</option>
	<option value="-04:00">(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz</option>
	<option value="-03:50">(GMT -3:30) Newfoundland</option>
	<option value="-03:00">(GMT -3:00) Brazil, Buenos Aires, Georgetown</option>
	<option value="-02:00">(GMT -2:00) Mid-Atlantic</option>
	<option value="-01:00">(GMT -1:00) Azores, Cape Verde Islands</option>
	<option value="+00:00" selected="selected">(GMT) Western Europe Time, London, Lisbon, Casablanca</option>
	<option value="+01:00">(GMT +1:00) Brussels, Copenhagen, Madrid, Paris</option>
	<option value="+02:00">(GMT +2:00) Kaliningrad, South Africa</option>
	<option value="+03:00">(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg</option>
	<option value="+03:50">(GMT +3:30) Tehran</option>
	<option value="+04:00">(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi</option>
	<option value="+04:50">(GMT +4:30) Kabul</option>
	<option value="+05:00">(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent</option>
	<option value="+05:50">(GMT +5:30) Bombay, Calcutta, Madras, New Delhi</option>
	<option value="+05:75">(GMT +5:45) Kathmandu, Pokhara</option>
	<option value="+06:00">(GMT +6:00) Almaty, Dhaka, Colombo</option>
	<option value="+06:50">(GMT +6:30) Yangon, Mandalay</option>
	<option value="+07:00">(GMT +7:00) Bangkok, Hanoi, Jakarta</option>
	<option value="+08:00">(GMT +8:00) Beijing, Perth, Singapore, Hong Kong</option>
	<option value="+08:75">(GMT +8:45) Eucla</option>
	<option value="+09:00">(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk</option>
	<option value="+09:50">(GMT +9:30) Adelaide, Darwin</option>
	<option value="+10:00">(GMT +10:00) Eastern Australia, Guam, Vladivostok</option>
	<option value="+10:50">(GMT +10:30) Lord Howe Island</option>
	<option value="+11:00">(GMT +11:00) Magadan, Solomon Islands, New Caledonia</option>
	<option value="+11:50">(GMT +11:30) Norfolk Island</option>
	<option value="+12:00">(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka</option>
	<option value="+12:75">(GMT +12:45) Chatham Islands</option>
	<option value="+13:00">(GMT +13:00) Apia, Nukualofa</option>
	<option value="+14:00">(GMT +14:00) Line Islands, Tokelau</option>
	</select>

nodesocket/gist:3919205

alketii commented Sep 27, 2016

goatandsheep commented Jul 20, 2017

mattjohnsonpint commented Aug 30, 2017 •

edited

Loading

jesraygarciano commented Feb 8, 2018

cccaldas commented Jul 4, 2018

ernestbangbuh commented Feb 1, 2019

roymoran commented Jun 21, 2019

soubhikchatterjee commented Jul 3, 2019

isat7 commented Sep 24, 2019

kamleshwebtech commented Feb 22, 2020

hkarakose commented Mar 18, 2020

irynazaiets commented Apr 17, 2020

prasadrajuv commented Sep 26, 2020

VIRGO96 commented Dec 19, 2020

epursimuove commented Dec 30, 2020

ericol commented Nov 16, 2021

aftabkhaliq commented Dec 8, 2021

mattjohnsonpint commented Dec 8, 2021

mcgingras commented Feb 3, 2022

tranchausky commented Mar 3, 2023 •

edited

Loading

Simvolick commented Mar 11, 2023

epursimuove commented May 19, 2023 •

edited

Loading

dorogoff commented Sep 13, 2023

vreemt commented Apr 25, 2024 •

edited

Loading

nodesocket/gist:3919205

alketii commented Sep 27, 2016

goatandsheep commented Jul 20, 2017

mattjohnsonpint commented Aug 30, 2017 • edited Loading

jesraygarciano commented Feb 8, 2018

cccaldas commented Jul 4, 2018

ernestbangbuh commented Feb 1, 2019

roymoran commented Jun 21, 2019

soubhikchatterjee commented Jul 3, 2019

isat7 commented Sep 24, 2019

kamleshwebtech commented Feb 22, 2020

hkarakose commented Mar 18, 2020

irynazaiets commented Apr 17, 2020

prasadrajuv commented Sep 26, 2020

VIRGO96 commented Dec 19, 2020

epursimuove commented Dec 30, 2020

ericol commented Nov 16, 2021

aftabkhaliq commented Dec 8, 2021

Laravel seeder for time Zones

mattjohnsonpint commented Dec 8, 2021

mcgingras commented Feb 3, 2022

tranchausky commented Mar 3, 2023 • edited Loading

Simvolick commented Mar 11, 2023

epursimuove commented May 19, 2023 • edited Loading

dorogoff commented Sep 13, 2023

vreemt commented Apr 25, 2024 • edited Loading

mattjohnsonpint commented Aug 30, 2017 •

edited

Loading

tranchausky commented Mar 3, 2023 •

edited

Loading

epursimuove commented May 19, 2023 •

edited

Loading

vreemt commented Apr 25, 2024 •

edited

Loading