Skip to content

Instantly share code, notes, and snippets.

@hesoyamcode

hesoyamcode/timezone_country.sql

Last active February 17, 2019 13:38
Show Gist options
  • Save hesoyamcode/4651119e93485dc48e97c5c756f74ec9 to your computer and use it in GitHub Desktop.
Save hesoyamcode/4651119e93485dc48e97c5c756f74ec9 to your computer and use it in GitHub Desktop.
Download ZIP
mysql timezone with country/city
Raw
timezone_country.sql
DROP TABLE IF EXISTS `timezones`;
CREATE TABLE `timezones` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`country_code` char(3) NOT NULL,
`zone_name` varchar(125) NOT NULL DEFAULT '',
`gmt_offset` char(6) DEFAULT NULL,
`dst_offset` char(6) DEFAULT NULL,
`raw_offset` char(6) DEFAULT NULL,
PRIMARY KEY(`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
INSERT INTO `timezones`
VALUES
(null, 'AD', 'Europe/Andorra', "+01:00", "+02:00", "+01:00"),
(null, 'AE', 'Asia/Dubai', "+04:00", "+04:00", "+04:00"),
(null, 'AF', 'Asia/Kabul', "+04:30", "+04:30", "+04:30"),
(null, 'AG', 'America/Antigua', "-04:00", "-04:00", "-04:00"),
(null, 'AI', 'America/Anguilla', "-04:00", "-04:00", "-04:00"),
(null, 'AL', 'Europe/Tirane', "+01:00", "+02:00", "+01:00"),
(null, 'AM', 'Asia/Yerevan', "+04:00", "+04:00", "+04:00"),
(null, 'AO', 'Africa/Luanda', "+01:00", "+01:00", "+01:00"),
(null, 'AQ', 'Antarctica/Casey', "+08:00", "+08:00", "+08:00"),
(null, 'AQ', 'Antarctica/Davis', "+07:00", "+07:00", "+07:00"),
(null, 'AQ', 'Antarctica/DumontDUrville', "+10:00", "+10:00", "+10:00"),
(null, 'AQ', 'Antarctica/Mawson', "+05:00", "+05:00", "+05:00"),
(null, 'AQ', 'Antarctica/McMurdo', "+13:00", "+12:00", "+12:00"),
(null, 'AQ', 'Antarctica/Palmer', "-03:00", "-04:00", "-04:00"),
(null, 'AQ', 'Antarctica/Rothera', "-03:00", "-03:00", "-03:00"),
(null, 'AQ', 'Antarctica/South_Pole', "+13:00", "+12:00", "+12:00"),
(null, 'AQ', 'Antarctica/Syowa', "+03:00", "+03:00", "+03:00"),
(null, 'AQ', 'Antarctica/Vostok', "+06:00", "+06:00", "+06:00"),
(null, 'AR', 'America/Argentina/Buenos_Aires', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Catamarca', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Cordoba', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Jujuy', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/La_Rioja', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Mendoza', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Rio_Gallegos', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Salta', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/San_Juan', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/San_Luis', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Tucuman', "-03:00", "-03:00", "-03:00"),
(null, 'AR', 'America/Argentina/Ushuaia', "-03:00", "-03:00", "-03:00"),
(null, 'AS', 'Pacific/Pago_Pago', "-11:00", "-11:00", "-11:00"),
(null, 'AT', 'Europe/Vienna', "+01:00", "+02:00", "+01:00"),
(null, 'AU', 'Antarctica/Macquarie', "+11:00", "+11:00", "+11:00"),
(null, 'AU', 'Australia/Adelaide', "+10:30", "+09:30", "+09:30"),
(null, 'AU', 'Australia/Brisbane', "+10:00", "+10:00", "+10:00"),
(null, 'AU', 'Australia/Broken_Hill', "+10:30", "+09:30", "+09:30"),
(null, 'AU', 'Australia/Currie', "+11:00", "+10:00", "+10:00"),
(null, 'AU', 'Australia/Darwin', "+09:30", "+09:30", "+09:30"),
(null, 'AU', 'Australia/Eucla', "+08.45", "+08.45", "+08.45"),
(null, 'AU', 'Australia/Hobart', "+11:00", "+10:00", "+10:00"),
(null, 'AU', 'Australia/Lindeman', "+10:00", "+10:00", "+10:00"),
(null, 'AU', 'Australia/Lord_Howe', "+11:00", "+10:30", "+10:30"),
(null, 'AU', 'Australia/Melbourne', "+11:00", "+10:00", "+10:00"),
(null, 'AU', 'Australia/Perth', "+08:00", "+08:00", "+08:00"),
(null, 'AU', 'Australia/Sydney', "+11:00", "+10:00", "+10:00"),
(null, 'AW', 'America/Aruba', "-04:00", "-04:00", "-04:00"),
(null, 'AX', 'Europe/Mariehamn', "+02:00", "+03:00", "+02:00"),
(null, 'AZ', 'Asia/Baku', "+04:00", "+05:00", "+04:00"),
(null, 'BA', 'Europe/Sarajevo', "+01:00", "+02:00", "+01:00"),
(null, 'BB', 'America/Barbados', "-04:00", "-04:00", "-04:00"),
(null, 'BD', 'Asia/Dhaka', "+06:00", "+06:00", "+06:00"),
(null, 'BE', 'Europe/Brussels', "+01:00", "+02:00", "+01:00"),
(null, 'BF', 'Africa/Ouagadougou', "+00:00", "+00:00", "+00:00"),
(null, 'BG', 'Europe/Sofia', "+02:00", "+03:00", "+02:00"),
(null, 'BH', 'Asia/Bahrain', "+03:00", "+03:00", "+03:00"),
(null, 'BI', 'Africa/Bujumbura', "+02:00", "+02:00", "+02:00"),
(null, 'BJ', 'Africa/Porto-Novo', "+01:00", "+01:00", "+01:00"),
(null, 'BL', 'America/St_Barthelemy', "-04:00", "-04:00", "-04:00"),
(null, 'BM', 'Atlantic/Bermuda', "-04:00", "-03:00", "-04:00"),
(null, 'BN', 'Asia/Brunei', "+08:00", "+08:00", "+08:00"),
(null, 'BO', 'America/La_Paz', "-04:00", "-04:00", "-04:00"),
(null, 'BQ', 'America/Kralendijk', "-04:00", "-04:00", "-04:00"),
(null, 'BR', 'America/Araguaina', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Bahia', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Belem', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Boa_Vista', "-04:00", "-04:00", "-04:00"),
(null, 'BR', 'America/Campo_Grande', "-03:00", "-04:00", "-04:00"),
(null, 'BR', 'America/Cuiaba', "-03:00", "-04:00", "-04:00"),
(null, 'BR', 'America/Eirunepe', "-05:00", "-05:00", "-05:00"),
(null, 'BR', 'America/Fortaleza', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Maceio', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Manaus', "-04:00", "-04:00", "-04:00"),
(null, 'BR', 'America/Noronha', "-02:00", "-02:00", "-02:00"),
(null, 'BR', 'America/Porto_Velho', "-04:00", "-04:00", "-04:00"),
(null, 'BR', 'America/Recife', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Rio_Branco', "-05:00", "-05:00", "-05:00"),
(null, 'BR', 'America/Santarem', "-03:00", "-03:00", "-03:00"),
(null, 'BR', 'America/Sao_Paulo', "-02:00", "-03:00", "-03:00"),
(null, 'BS', 'America/Nassau', "-05:00", "-04:00", "-05:00"),
(null, 'BT', 'Asia/Thimphu', "+06:00", "+06:00", "+06:00"),
(null, 'BW', 'Africa/Gaborone', "+02:00", "+02:00", "+02:00"),
(null, 'BY', 'Europe/Minsk', "+03:00", "+03:00", "+03:00"),
(null, 'BZ', 'America/Belize', "-06:00", "-06:00", "-06:00"),
(null, 'CA', 'America/Atikokan', "-05:00", "-05:00", "-05:00"),
(null, 'CA', 'America/Blanc-Sablon', "-04:00", "-04:00", "-04:00"),
(null, 'CA', 'America/Cambridge_Bay', "-07:00", "-06:00", "-07:00"),
(null, 'CA', 'America/Creston', "-07:00", "-07:00", "-07:00"),
(null, 'CA', 'America/Dawson', "-08:00", "-07:00", "-08:00"),
(null, 'CA', 'America/Dawson_Creek', "-07:00", "-07:00", "-07:00"),
(null, 'CA', 'America/Edmonton', "-07:00", "-06:00", "-07:00"),
(null, 'CA', 'America/Glace_Bay', "-04:00", "-03:00", "-04:00"),
(null, 'CA', 'America/Goose_Bay', "-04:00", "-03:00", "-04:00"),
(null, 'CA', 'America/Halifax', "-04:00", "-03:00", "-04:00"),
(null, 'CA', 'America/Inuvik', "-07:00", "-06:00", "-07:00"),
(null, 'CA', 'America/Iqaluit', "-05:00", "-04:00", "-05:00"),
(null, 'CA', 'America/Moncton', "-04:00", "-03:00", "-04:00"),
(null, 'CA', 'America/Montreal', "-05:00", "-04:00", "-05:00"),
(null, 'CA', 'America/Nipigon', "-05:00", "-04:00", "-05:00"),
(null, 'CA', 'America/Pangnirtung', "-05:00", "-04:00", "-05:00"),
(null, 'CA', 'America/Rainy_River', "-06:00", "-05:00", "-06:00"),
(null, 'CA', 'America/Rankin_Inlet', "-06:00", "-05:00", "-06:00"),
(null, 'CA', 'America/Regina', "-06:00", "-06:00", "-06:00"),
(null, 'CA', 'America/Resolute', "-06:00", "-05:00", "-06:00"),
(null, 'CA', 'America/St_Johns', "-03:30", "-02:30", "-03:30"),
(null, 'CA', 'America/Swift_Current', "-06:00", "-06:00", "-06:00"),
(null, 'CA', 'America/Thunder_Bay', "-05:00", "-04:00", "-05:00"),
(null, 'CA', 'America/Toronto', "-05:00", "-04:00", "-05:00"),
(null, 'CA', 'America/Vancouver', "-08:00", "-07:00", "-08:00"),
(null, 'CA', 'America/Whitehorse', "-08:00", "-07:00", "-08:00"),
(null, 'CA', 'America/Winnipeg', "-06:00", "-05:00", "-06:00"),
(null, 'CA', 'America/Yellowknife', "-07:00", "-06:00", "-07:00"),
(null, 'CC', 'Indian/Cocos', "+06:30", "+06:30", "+06:30"),
(null, 'CD', 'Africa/Kinshasa', "+01:00", "+01:00", "+01:00"),
(null, 'CD', 'Africa/Lubumbashi', "+02:00", "+02:00", "+02:00"),
(null, 'CF', 'Africa/Bangui', "+01:00", "+01:00", "+01:00"),
(null, 'CG', 'Africa/Brazzaville', "+01:00", "+01:00", "+01:00"),
(null, 'CH', 'Europe/Zurich', "+01:00", "+02:00", "+01:00"),
(null, 'CI', 'Africa/Abidjan', "+00:00", "+00:00", "+00:00"),
(null, 'CK', 'Pacific/Rarotonga', "-10:00", "-10:00", "-10:00"),
(null, 'CL', 'America/Santiago', "-03:00", "-04:00", "-04:00"),
(null, 'CL', 'Pacific/Easter', "-05:00", "-06:00", "-06:00"),
(null, 'CM', 'Africa/Douala', "+01:00", "+01:00", "+01:00"),
(null, 'CN', 'Asia/Chongqing', "+08:00", "+08:00", "+08:00"),
(null, 'CN', 'Asia/Harbin', "+08:00", "+08:00", "+08:00"),
(null, 'CN', 'Asia/Kashgar', "+08:00", "+08:00", "+08:00"),
(null, 'CN', 'Asia/Shanghai', "+08:00", "+08:00", "+08:00"),
(null, 'CN', 'Asia/Urumqi', "+08:00", "+08:00", "+08:00"),
(null, 'CO', 'America/Bogota', "-05:00", "-05:00", "-05:00"),
(null, 'CR', 'America/Costa_Rica', "-06:00", "-06:00", "-06:00"),
(null, 'CU', 'America/Havana', "-05:00", "-04:00", "-05:00"),
(null, 'CV', 'Atlantic/Cape_Verde', "-01:00", "-01:00", "-01:00"),
(null, 'CW', 'America/Curacao', "-04:00", "-04:00", "-04:00"),
(null, 'CX', 'Indian/Christmas', "+07:00", "+07:00", "+07:00"),
(null, 'CY', 'Asia/Nicosia', "+02:00", "+03:00", "+02:00"),
(null, 'CZ', 'Europe/Prague', "+01:00", "+02:00", "+01:00"),
(null, 'DE', 'Europe/Berlin', "+01:00", "+02:00", "+01:00"),
(null, 'DE', 'Europe/Busingen', "+01:00", "+02:00", "+01:00"),
(null, 'DJ', 'Africa/Djibouti', "+03:00", "+03:00", "+03:00"),
(null, 'DK', 'Europe/Copenhagen', "+01:00", "+02:00", "+01:00"),
(null, 'DM', 'America/Dominica', "-04:00", "-04:00", "-04:00"),
(null, 'DO', 'America/Santo_Domingo', "-04:00", "-04:00", "-04:00"),
(null, 'DZ', 'Africa/Algiers', "+01:00", "+01:00", "+01:00"),
(null, 'EC', 'America/Guayaquil', "-05:00", "-05:00", "-05:00"),
(null, 'EC', 'Pacific/Galapagos', "-06:00", "-06:00", "-06:00"),
(null, 'EE', 'Europe/Tallinn', "+02:00", "+03:00", "+02:00"),
(null, 'EG', 'Africa/Cairo', "+02:00", "+02:00", "+02:00"),
(null, 'EH', 'Africa/El_Aaiun', "+00:00", "+00:00", "+00:00"),
(null, 'ER', 'Africa/Asmara', "+03:00", "+03:00", "+03:00"),
(null, 'ES', 'Africa/Ceuta', "+01:00", "+02:00", "+01:00"),
(null, 'ES', 'Atlantic/Canary', "+00:00", "+01:00", "+00:00"),
(null, 'ES', 'Europe/Madrid', "+01:00", "+02:00", "+01:00"),
(null, 'ET', 'Africa/Addis_Ababa', "+03:00", "+03:00", "+03:00"),
(null, 'FI', 'Europe/Helsinki', "+02:00", "+03:00", "+02:00"),
(null, 'FJ', 'Pacific/Fiji', "+13:00", "+12:00", "+12:00"),
(null, 'FK', 'Atlantic/Stanley', "-03:00", "-03:00", "-03:00"),
(null, 'FM', 'Pacific/Chuuk', "+10:00", "+10:00", "+10:00"),
(null, 'FM', 'Pacific/Kosrae', "+11:00", "+11:00", "+11:00"),
(null, 'FM', 'Pacific/Pohnpei', "+11:00", "+11:00", "+11:00"),
(null, 'FO', 'Atlantic/Faroe', "+00:00", "+01:00", "+00:00"),
(null, 'FR', 'Europe/Paris', "+01:00", "+02:00", "+01:00"),
(null, 'GA', 'Africa/Libreville', "+01:00", "+01:00", "+01:00"),
(null, 'GB', 'Europe/London', "+00:00", "+01:00", "+00:00"),
(null, 'GD', 'America/Grenada', "-04:00", "-04:00", "-04:00"),
(null, 'GE', 'Asia/Tbilisi', "+04:00", "+04:00", "+04:00"),
(null, 'GF', 'America/Cayenne', "-03:00", "-03:00", "-03:00"),
(null, 'GG', 'Europe/Guernsey', "+00:00", "+01:00", "+00:00"),
(null, 'GH', 'Africa/Accra', "+00:00", "+00:00", "+00:00"),
(null, 'GI', 'Europe/Gibraltar', "+01:00", "+02:00", "+01:00"),
(null, 'GL', 'America/Danmarkshavn', "+00:00", "+00:00", "+00:00"),
(null, 'GL', 'America/Godthab', "-03:00", "-02:00", "-03:00"),
(null, 'GL', 'America/Scoresbysund', "-01:00", "+00:00", "-01:00"),
(null, 'GL', 'America/Thule', "-04:00", "-03:00", "-04:00"),
(null, 'GM', 'Africa/Banjul', "+00:00", "+00:00", "+00:00"),
(null, 'GN', 'Africa/Conakry', "+00:00", "+00:00", "+00:00"),
(null, 'GP', 'America/Guadeloupe', "-04:00", "-04:00", "-04:00"),
(null, 'GQ', 'Africa/Malabo', "+01:00", "+01:00", "+01:00"),
(null, 'GR', 'Europe/Athens', "+02:00", "+03:00", "+02:00"),
(null, 'GS', 'Atlantic/South_Georgia', "-02:00", "-02:00", "-02:00"),
(null, 'GT', 'America/Guatemala', "-06:00", "-06:00", "-06:00"),
(null, 'GU', 'Pacific/Guam', "+10:00", "+10:00", "+10:00"),
(null, 'GW', 'Africa/Bissau', "+00:00", "+00:00", "+00:00"),
(null, 'GY', 'America/Guyana', "-04:00", "-04:00", "-04:00"),
(null, 'HK', 'Asia/Hong_Kong', "+08:00", "+08:00", "+08:00"),
(null, 'HN', 'America/Tegucigalpa', "-06:00", "-06:00", "-06:00"),
(null, 'HR', 'Europe/Zagreb', "+01:00", "+02:00", "+01:00"),
(null, 'HT', 'America/Port-au-Prince', "-05:00", "-04:00", "-05:00"),
(null, 'HU', 'Europe/Budapest', "+01:00", "+02:00", "+01:00"),
(null, 'ID', 'Asia/Jakarta', "+07:00", "+07:00", "+07:00"),
(null, 'ID', 'Asia/Jayapura', "+09:00", "+09:00", "+09:00"),
(null, 'ID', 'Asia/Makassar', "+08:00", "+08:00", "+08:00"),
(null, 'ID', 'Asia/Pontianak', "+07:00", "+07:00", "+07:00"),
(null, 'IE', 'Europe/Dublin', "+00:00", "+01:00", "+00:00"),
(null, 'IL', 'Asia/Jerusalem', "+02:00", "+03:00", "+02:00"),
(null, 'IM', 'Europe/Isle_of_Man', "+00:00", "+01:00", "+00:00"),
(null, 'IN', 'Asia/Kolkata', "+05:30", "+05:30", "+05:30"),
(null, 'IO', 'Indian/Chagos', "+06:00", "+06:00", "+06:00"),
(null, 'IQ', 'Asia/Baghdad', "+03:00", "+03:00", "+03:00"),
(null, 'IR', 'Asia/Tehran', "+03:30", "+04:30", "+03:30"),
(null, 'IS', 'Atlantic/Reykjavik', "+00:00", "+00:00", "+00:00"),
(null, 'IT', 'Europe/Rome', "+01:00", "+02:00", "+01:00"),
(null, 'JE', 'Europe/Jersey', "+00:00", "+01:00", "+00:00"),
(null, 'JM', 'America/Jamaica', "-05:00", "-05:00", "-05:00"),
(null, 'JO', 'Asia/Amman', "+02:00", "+03:00", "+02:00"),
(null, 'JP', 'Asia/Tokyo', "+09:00", "+09:00", "+09:00"),
(null, 'KE', 'Africa/Nairobi', "+03:00", "+03:00", "+03:00"),
(null, 'KG', 'Asia/Bishkek', "+06:00", "+06:00", "+06:00"),
(null, 'KH', 'Asia/Phnom_Penh', "+07:00", "+07:00", "+07:00"),
(null, 'KI', 'Pacific/Enderbury', "+13:00", "+13:00", "+13:00"),
(null, 'KI', 'Pacific/Kiritimati', "+14:00", "+14:00", "+14:00"),
(null, 'KI', 'Pacific/Tarawa', "+12:00", "+12:00", "+12:00"),
(null, 'KM', 'Indian/Comoro', "+03:00", "+03:00", "+03:00"),
(null, 'KN', 'America/St_Kitts', "-04:00", "-04:00", "-04:00"),
(null, 'KP', 'Asia/Pyongyang', "+09:00", "+09:00", "+09:00"),
(null, 'KR', 'Asia/Seoul', "+09:00", "+09:00", "+09:00"),
(null, 'KW', 'Asia/Kuwait', "+03:00", "+03:00", "+03:00"),
(null, 'KY', 'America/Cayman', "-05:00", "-05:00", "-05:00"),
(null, 'KZ', 'Asia/Almaty', "+06:00", "+06:00", "+06:00"),
(null, 'KZ', 'Asia/Aqtau', "+05:00", "+05:00", "+05:00"),
(null, 'KZ', 'Asia/Aqtobe', "+05:00", "+05:00", "+05:00"),
(null, 'KZ', 'Asia/Oral', "+05:00", "+05:00", "+05:00"),
(null, 'KZ', 'Asia/Qyzylorda', "+06:00", "+06:00", "+06:00"),
(null, 'LA', 'Asia/Vientiane', "+07:00", "+07:00", "+07:00"),
(null, 'LB', 'Asia/Beirut', "+02:00", "+03:00", "+02:00"),
(null, 'LC', 'America/St_Lucia', "-04:00", "-04:00", "-04:00"),
(null, 'LI', 'Europe/Vaduz', "+01:00", "+02:00", "+01:00"),
(null, 'LK', 'Asia/Colombo', "+05:30", "+05:30", "+05:30"),
(null, 'LR', 'Africa/Monrovia', "+00:00", "+00:00", "+00:00"),
(null, 'LS', 'Africa/Maseru', "+02:00", "+02:00", "+02:00"),
(null, 'LT', 'Europe/Vilnius', "+02:00", "+03:00", "+02:00"),
(null, 'LU', 'Europe/Luxembourg', "+01:00", "+02:00", "+01:00"),
(null, 'LV', 'Europe/Riga', "+02:00", "+03:00", "+02:00"),
(null, 'LY', 'Africa/Tripoli', "+02:00", "+02:00", "+02:00"),
(null, 'MA', 'Africa/Casablanca', "+00:00", "+00:00", "+00:00"),
(null, 'MC', 'Europe/Monaco', "+01:00", "+02:00", "+01:00"),
(null, 'MD', 'Europe/Chisinau', "+02:00", "+03:00", "+02:00"),
(null, 'ME', 'Europe/Podgorica', "+01:00", "+02:00", "+01:00"),
(null, 'MF', 'America/Marigot', "-04:00", "-04:00", "-04:00"),
(null, 'MG', 'Indian/Antananarivo', "+03:00", "+03:00", "+03:00"),
(null, 'MH', 'Pacific/Kwajalein', "+12:00", "+12:00", "+12:00"),
(null, 'MH', 'Pacific/Majuro', "+12:00", "+12:00", "+12:00"),
(null, 'MK', 'Europe/Skopje', "+01:00", "+02:00", "+01:00"),
(null, 'ML', 'Africa/Bamako', "+00:00", "+00:00", "+00:00"),
(null, 'MM', 'Asia/Rangoon', "+06:30", "+06:30", "+06:30"),
(null, 'MN', 'Asia/Choibalsan', "+08:00", "+08:00", "+08:00"),
(null, 'MN', 'Asia/Hovd', "+07:00", "+07:00", "+07:00"),
(null, 'MN', 'Asia/Ulaanbaatar', "+08:00", "+08:00", "+08:00"),
(null, 'MO', 'Asia/Macau', "+08:00", "+08:00", "+08:00"),
(null, 'MP', 'Pacific/Saipan', "+10:00", "+10:00", "+10:00"),
(null, 'MQ', 'America/Martinique', "-04:00", "-04:00", "-04:00"),
(null, 'MR', 'Africa/Nouakchott', "+00:00", "+00:00", "+00:00"),
(null, 'MS', 'America/Montserrat', "-04:00", "-04:00", "-04:00"),
(null, 'MT', 'Europe/Malta', "+01:00", "+02:00", "+01:00"),
(null, 'MU', 'Indian/Mauritius', "+04:00", "+04:00", "+04:00"),
(null, 'MV', 'Indian/Maldives', "+05:00", "+05:00", "+05:00"),
(null, 'MW', 'Africa/Blantyre', "+02:00", "+02:00", "+02:00"),
(null, 'MX', 'America/Bahia_Banderas', "-06:00", "-05:00", "-06:00"),
(null, 'MX', 'America/Cancun', "-06:00", "-05:00", "-06:00"),
(null, 'MX', 'America/Chihuahua', "-07:00", "-06:00", "-07:00"),
(null, 'MX', 'America/Hermosillo', "-07:00", "-07:00", "-07:00"),
(null, 'MX', 'America/Matamoros', "-06:00", "-05:00", "-06:00"),
(null, 'MX', 'America/Mazatlan', "-07:00", "-06:00", "-07:00"),
(null, 'MX', 'America/Merida', "-06:00", "-05:00", "-06:00"),
(null, 'MX', 'America/Mexico_City', "-06:00", "-05:00", "-06:00"),
(null, 'MX', 'America/Monterrey', "-06:00", "-05:00", "-06:00"),
(null, 'MX', 'America/Ojinaga', "-07:00", "-06:00", "-07:00"),
(null, 'MX', 'America/Santa_Isabel', "-08:00", "-07:00", "-08:00"),
(null, 'MX', 'America/Tijuana', "-08:00", "-07:00", "-08:00"),
(null, 'MY', 'Asia/Kuala_Lumpur', "+08:00", "+08:00", "+08:00"),
(null, 'MY', 'Asia/Kuching', "+08:00", "+08:00", "+08:00"),
(null, 'MZ', 'Africa/Maputo', "+02:00", "+02:00", "+02:00"),
(null, 'NA', 'Africa/Windhoek', "+02:00", "+01:00", "+01:00"),
(null, 'NC', 'Pacific/Noumea', "+11:00", "+11:00", "+11:00"),
(null, 'NE', 'Africa/Niamey', "+01:00", "+01:00", "+01:00"),
(null, 'NF', 'Pacific/Norfolk', "+11:30", "+11:30", "+11:30"),
(null, 'NG', 'Africa/Lagos', "+01:00", "+01:00", "+01:00"),
(null, 'NI', 'America/Managua', "-06:00", "-06:00", "-06:00"),
(null, 'NL', 'Europe/Amsterdam', "+01:00", "+02:00", "+01:00"),
(null, 'NO', 'Europe/Oslo', "+01:00", "+02:00", "+01:00"),
(null, 'NP', 'Asia/Kathmandu', "+05:45", "+05:45", "+05:45"),
(null, 'NR', 'Pacific/Nauru', "+12:00", "+12:00", "+12:00"),
(null, 'NU', 'Pacific/Niue', "-11:00", "-11:00", "-11:00"),
(null, 'NZ', 'Pacific/Auckland', "+13:00", "+12:00", "+12:00"),
(null, 'NZ', 'Pacific/Chatham', "12.45", "+13.45", "+12.45"),
(null, 'OM', 'Asia/Muscat', "+04:00", "+04:00", "+04:00"),
(null, 'PA', 'America/Panama', "-05:00", "-05:00", "-05:00"),
(null, 'PE', 'America/Lima', "-05:00", "-05:00", "-05:00"),
(null, 'PF', 'Pacific/Gambier', "-09:00", "-09:00", "-09:00"),
(null, 'PF', 'Pacific/Marquesas', "-09:30", "-09:30", "-09:30"),
(null, 'PF', 'Pacific/Tahiti', "-10:00", "-10:00", "-10:00"),
(null, 'PG', 'Pacific/Port_Moresby', "+10:00", "+10:00", "+10:00"),
(null, 'PH', 'Asia/Manila', "+08:00", "+08:00", "+08:00"),
(null, 'PK', 'Asia/Karachi', "+05:00", "+05:00", "+05:00"),
(null, 'PL', 'Europe/Warsaw', "+01:00", "+02:00", "+01:00"),
(null, 'PM', 'America/Miquelon', "-03:00", "-02:00", "-03:00"),
(null, 'PN', 'Pacific/Pitcairn', "-08:00", "-08:00", "-08:00"),
(null, 'PR', 'America/Puerto_Rico', "-04:00", "-04:00", "-04:00"),
(null, 'PS', 'Asia/Gaza', "+02:00", "+03:00", "+02:00"),
(null, 'PS', 'Asia/Hebron', "+02:00", "+03:00", "+02:00"),
(null, 'PT', 'Atlantic/Azores', "-01:00", "+00:00", "-01:00"),
(null, 'PT', 'Atlantic/Madeira', "+00:00", "+01:00", "+00:00"),
(null, 'PT', 'Europe/Lisbon', "+00:00", "+01:00", "+00:00"),
(null, 'PW', 'Pacific/Palau', "+09:00", "+09:00", "+09:00"),
(null, 'PY', 'America/Asuncion', "-03:00", "-04:00", "-04:00"),
(null, 'QA', 'Asia/Qatar', "+03:00", "+03:00", "+03:00"),
(null, 'RE', 'Indian/Reunion', "+04:00", "+04:00", "+04:00"),
(null, 'RO', 'Europe/Bucharest', "+02:00", "+03:00", "+02:00"),
(null, 'RS', 'Europe/Belgrade', "+01:00", "+02:00", "+01:00"),
(null, 'RU', 'Asia/Anadyr', "+12:00", "+12:00", "+12:00"),
(null, 'RU', 'Asia/Irkutsk', "+09:00", "+09:00", "+09:00"),
(null, 'RU', 'Asia/Kamchatka', "+12:00", "+12:00", "+12:00"),
(null, 'RU', 'Asia/Khandyga', "+10:00", "+10:00", "+10:00"),
(null, 'RU', 'Asia/Krasnoyarsk', "+08:00", "+08:00", "+08:00"),
(null, 'RU', 'Asia/Magadan', "+12:00", "+12:00", "+12:00"),
(null, 'RU', 'Asia/Novokuznetsk', "+07:00", "+07:00", "+07:00"),
(null, 'RU', 'Asia/Novosibirsk', "+07:00", "+07:00", "+07:00"),
(null, 'RU', 'Asia/Omsk', "+07:00", "+07:00", "+07:00"),
(null, 'RU', 'Asia/Sakhalin', "+11:00", "+11:00", "+11:00"),
(null, 'RU', 'Asia/Ust-Nera', "+11:00", "+11:00", "+11:00"),
(null, 'RU', 'Asia/Vladivostok', "+11:00", "+11:00", "+11:00"),
(null, 'RU', 'Asia/Yakutsk', "+10:00", "+10:00", "+10:00"),
(null, 'RU', 'Asia/Yekaterinburg', "+06:00", "+06:00", "+06:00"),
(null, 'RU', 'Europe/Kaliningrad', "+03:00", "+03:00", "+03:00"),
(null, 'RU', 'Europe/Moscow', "+04:00", "+04:00", "+04:00"),
(null, 'RU', 'Europe/Samara', "+04:00", "+04:00", "+04:00"),
(null, 'RU', 'Europe/Volgograd', "+04:00", "+04:00", "+04:00"),
(null, 'RW', 'Africa/Kigali', "+02:00", "+02:00", "+02:00"),
(null, 'SA', 'Asia/Riyadh', "+03:00", "+03:00", "+03:00"),
(null, 'SB', 'Pacific/Guadalcanal', "+11:00", "+11:00", "+11:00"),
(null, 'SC', 'Indian/Mahe', "+04:00", "+04:00", "+04:00"),
(null, 'SD', 'Africa/Khartoum', "+03:00", "+03:00", "+03:00"),
(null, 'SE', 'Europe/Stockholm', "+01:00", "+02:00", "+01:00"),
(null, 'SG', 'Asia/Singapore', "+08:00", "+08:00", "+08:00"),
(null, 'SH', 'Atlantic/St_Helena', "+00:00", "+00:00", "+00:00"),
(null, 'SI', 'Europe/Ljubljana', "+01:00", "+02:00", "+01:00"),
(null, 'SJ', 'Arctic/Longyearbyen', "+01:00", "+02:00", "+01:00"),
(null, 'SK', 'Europe/Bratislava', "+01:00", "+02:00", "+01:00"),
(null, 'SL', 'Africa/Freetown', "+00:00", "+00:00", "+00:00"),
(null, 'SM', 'Europe/San_Marino', "+01:00", "+02:00", "+01:00"),
(null, 'SN', 'Africa/Dakar', "+00:00", "+00:00", "+00:00"),
(null, 'SO', 'Africa/Mogadishu', "+03:00", "+03:00", "+03:00"),
(null, 'SR', 'America/Paramaribo', "-03:00", "-03:00", "-03:00"),
(null, 'SS', 'Africa/Juba', "+03:00", "+03:00", "+03:00"),
(null, 'ST', 'Africa/Sao_Tome', "+00:00", "+00:00", "+00:00"),
(null, 'SV', 'America/El_Salvador', "-06:00", "-06:00", "-06:00"),
(null, 'SX', 'America/Lower_Princes', "-04:00", "-04:00", "-04:00"),
(null, 'SY', 'Asia/Damascus', "+02:00", "+03:00", "+02:00"),
(null, 'SZ', 'Africa/Mbabane', "+02:00", "+02:00", "+02:00"),
(null, 'TC', 'America/Grand_Turk', "-05:00", "-04:00", "-05:00"),
(null, 'TD', 'Africa/Ndjamena', "+01:00", "+01:00", "+01:00"),
(null, 'TF', 'Indian/Kerguelen', "+05:00", "+05:00", "+05:00"),
(null, 'TG', 'Africa/Lome', "+00:00", "+00:00", "+00:00"),
(null, 'TH', 'Asia/Bangkok', "+07:00", "+07:00", "+07:00"),
(null, 'TJ', 'Asia/Dushanbe', "+05:00", "+05:00", "+05:00"),
(null, 'TK', 'Pacific/Fakaofo', "+13:00", "+13:00", "+13:00"),
(null, 'TL', 'Asia/Dili', "+09:00", "+09:00", "+09:00"),
(null, 'TM', 'Asia/Ashgabat', "+05:00", "+05:00", "+05:00"),
(null, 'TN', 'Africa/Tunis', "+01:00", "+01:00", "+01:00"),
(null, 'TO', 'Pacific/Tongatapu', "+13:00", "+13:00", "+13:00"),
(null, 'TR', 'Europe/Istanbul', "+02:00", "+03:00", "+02:00"),
(null, 'TT', 'America/Port_of_Spain', "-04:00", "-04:00", "-04:00"),
(null, 'TV', 'Pacific/Funafuti', "+12:00", "+12:00", "+12:00"),
(null, 'TW','Asia/Taipei', "+08:00", "+08:00", "+08:00"),
(null, 'TZ','Africa/Dar_es_Salaam', "+03:00", "+03:00", "+03:00"),
(null, 'UA','Europe/Kiev', "+02:00", "+03:00", "+02:00"),
(null, 'UA','Europe/Simferopol', "+02:00", "+04:00", "+04:00"),
(null, 'UA','Europe/Uzhgorod', "+02:00", "+03:00", "+02:00"),
(null, 'UA','Europe/Zaporozhye', "+02:00", "+03:00", "+02:00"),
(null, 'UG','Africa/Kampala', "+03:00", "+03:00", "+03:00"),
(null, 'UM','Pacific/Johnston',"-10:00","-10:00","-10:00"),
(null, 'UM','Pacific/Midway',"-11:00","-11:00","-11:00"),
(null, 'UM','Pacific/Wake', "+12:00", "+12:00", "+12:00"),
(null, 'US','America/Adak',"-10:00","-09:00","-10:00"),
(null, 'US','America/Anchorage',"-09:00","-08:00","-09:00"),
(null, 'US','America/Boise',"-07:00","-06:00","-07:00"),
(null, 'US','America/Chicago',"-06:00","-05:00","-06:00"),
(null, 'US','America/Denver',"-07:00","-06:00","-07:00"),
(null, 'US','America/Detroit',"-05:00","-04:00","-05:00"),
(null, 'US','America/Indiana/Indianapolis',"-05:00","-04:00","-05:00"),
(null, 'US','America/Indiana/Knox',"-06:00","-05:00","-06:00"),
(null, 'US','America/Indiana/Marengo',"-05:00","-04:00","-05:00"),
(null, 'US','America/Indiana/Petersburg',"-05:00","-04:00","-05:00"),
(null, 'US','America/Indiana/Tell_City',"-06:00","-05:00","-06:00"),
(null, 'US','America/Indiana/Vevay',"-05:00","-04:00","-05:00"),
(null, 'US','America/Indiana/Vincennes',"-05:00","-04:00","-05:00"),
(null, 'US','America/Indiana/Winamac',"-05:00","-04:00","-05:00"),
(null, 'US','America/Juneau',"-09:00","-08:00","-09:00"),
(null, 'US','America/Kentucky/Louisville',"-05:00","-04:00","-05:00"),
(null, 'US','America/Kentucky/Monticello',"-05:00","-04:00","-05:00"),
(null, 'US','America/Los_Angeles',"-08:00","-07:00","-08:00"),
(null, 'US','America/Menominee',"-06:00","-05:00","-06:00"),
(null, 'US','America/Metlakatla',"-08:00","-08:00","-08:00"),
(null, 'US','America/New_York',"-05:00","-04:00","-05:00"),
(null, 'US','America/Nome',"-09:00","-08:00","-09:00"),
(null, 'US','America/North_Dakota/Beulah',"-06:00","-05:00","-06:00"),
(null, 'US','America/North_Dakota/Center',"-06:00","-05:00","-06:00"),
(null, 'US','America/North_Dakota/New_Salem',"-06:00","-05:00","-06:00"),
(null, 'US','America/Phoenix',"-07:00","-07:00","-07:00"),
(null, 'US','America/Shiprock',"-07:00","-06:00","-07:00"),
(null, 'US','America/Sitka',"-09:00","-08:00","-09:00"),
(null, 'US','America/Yakutat',"-09:00","-08:00","-09:00"),
(null, 'US','Pacific/Honolulu',"-10:00","-10:00","-10:00"),
(null, 'UY','America/Montevideo',"-02:00","-03:00","-03:00"),
(null, 'UZ','Asia/Samarkand', "+05:00", "+05:00", "+05:00"),
(null, 'UZ','Asia/Tashkent', "+05:00", "+05:00", "+05:00"),
(null, 'VA','Europe/Vatican', "+01:00", "+02:00", "+01:00"),
(null, 'VC','America/St_Vincent',"-04:00","-04:00","-04:00"),
(null, 'VE','America/Caracas',"-04:30","-04:30","-04:30"),
(null, 'VG','America/Tortola',"-04:00","-04:00","-04:00"),
(null, 'VI','America/St_Thomas',"-04:00","-04:00","-04:00"),
(null, 'VN','Asia/Ho_Chi_Minh', "+07:00", "+07:00", "+07:00"),
(null, 'VU','Pacific/Efate', "+11:00", "+11:00", "+11:00"),
(null, 'WF','Pacific/Wallis', "+12:00", "+12:00", "+12:00"),
(null, 'WS','Pacific/Apia', "+14:00", "+14:00", "+14:00"),
(null, 'YE','Asia/Aden', "+03:00", "+03:00", "+03:00"),
(null, 'YT','Indian/Mayotte', "+03:00", "+03:00", "+03:00"),
(null, 'ZA','Africa/Johannesburg', "+02:00", "+02:00", "+02:00"),
(null, 'ZM','Africa/Lusaka', "+02:00", "+02:00", "+02:00"),
(null, 'ZW','Africa/Harare', "+02:00", "+02:00", "+02:00");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment