Scout Database Model (CR)

Table: TimeZone

March 25, 2025

Contributed by:

Static table, do not change.

A static table that contains all known time zones of Scout.

ColumnName	DataType	Key	Not Null	Comment
TimeZoneID	INTEGER	PK	NN	Unique ID of time zone
Name	NVARCHAR(255)		NN	Zone name (e.g Berlin GMT+1, London GMT)
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	TimeZoneID

How to create

    CREATE TABLE TimeZone(
    TimeZoneID INTEGER NOT NULL,
    Name NVARCHAR(255) NOT NULL,
    ReservedString1 NVARCHAR(255),
    ReservedString2 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    PRIMARY KEY (TimeZoneID));
  

How to initialize

    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(1,'America/Adak');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(2,'Asia/Aden');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(3,'Asia/Almaty');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(4,'Asia/Amman');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(5,'Europe/Amsterdam');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(6,'Asia/Anadyr');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(7,'America/Anchorage');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(8,'Europe/Andorra');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(9,'America/Anguilla');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(10,'America/Antigua');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(11,'Asia/Aqtau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(12,'Asia/Aqtobe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(13,'America/Araguaina');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(14,'America/Aruba');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(15,'Asia/Ashgabat');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(16,'America/Asuncion');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(17,'Europe/Athens');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(18,'America/Atka');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(19,'Asia/Baghdad');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(20,'Asia/Bahrain');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(21,'Asia/Baku');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(22,'Asia/Bangkok');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(23,'America/Barbados');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(24,'Asia/Beirut');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(25,'America/Belem');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(26,'Europe/Belfast');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(27,'Europe/Belgrade');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(28,'America/Belize');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(29,'Europe/Berlin');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(30,'Asia/Bishkek');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(31,'America/Boa_Vista');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(32,'America/Bogota');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(33,'America/Boise');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(34,'Europe/Bratislava');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(35,'Asia/Brunei');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(36,'Europe/Brussels');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(37,'Europe/Bucharest');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(38,'Europe/Budapest');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(39,'America/Argentina/Buenos_Aires');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(40,'Asia/Calcutta');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(41,'America/Cambridge_Bay');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(42,'America/Cancun');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(43,'America/Caracas');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(44,'America/Argentina/Catamarca');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(45,'America/Cayenne');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(46,'America/Cayman');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(47,'America/Chicago');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(48,'America/Chihuahua');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(49,'Europe/Chisinau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(50,'Asia/Choibalsan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(51,'Asia/Chongqing');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(52,'Asia/Chungking');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(53,'Asia/Colombo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(54,'Europe/Copenhagen');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(55,'America/Argentina/Cordoba');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(56,'America/Costa_Rica');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(57,'America/Cuiaba');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(58,'America/Curacao');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(59,'Asia/Dacca');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(60,'Asia/Damascus');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(61,'America/Danmarkshavn');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(62,'America/Dawson');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(63,'America/Dawson_Creek');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(64,'America/Denver');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(65,'America/Detroit');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(66,'Asia/Dhaka');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(67,'Asia/Dili');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(68,'America/Dominica');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(69,'Asia/Dubai');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(70,'Europe/Dublin');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(71,'Asia/Dushanbe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(72,'America/Edmonton');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(73,'America/Eirunepe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(74,'America/El_Salvador');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(75,'America/Ensenada');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(76,'America/Fort_Wayne');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(77,'America/Fortaleza');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(78,'Asia/Gaza');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(79,'Europe/Gibraltar');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(80,'America/Glace_Bay');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(81,'America/Godthab');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(82,'America/Goose_Bay');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(83,'America/Grand_Turk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(84,'America/Grenada');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(85,'America/Guadeloupe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(86,'America/Guatemala');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(87,'America/Guayaquil');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(88,'America/Guyana');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(89,'America/Halifax');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(90,'Asia/Harbin');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(91,'America/Havana');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(92,'Europe/Helsinki');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(93,'America/Hermosillo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(94,'Asia/Hong_Kong');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(95,'Asia/Hovd');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(96,'America/Indiana/Indianapolis');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(97,'America/Inuvik');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(98,'America/Iqaluit');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(99,'Asia/Irkutsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(100,'Europe/Istanbul');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(101,'Asia/Jakarta');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(102,'America/Jamaica');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(103,'Asia/Jayapura');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(104,'Asia/Jerusalem');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(105,'America/Argentina/Jujuy');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(106,'America/Juneau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(107,'Asia/Kabul');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(108,'Europe/Kaliningrad');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(109,'Asia/Kamchatka');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(110,'Asia/Karachi');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(111,'Asia/Kashgar');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(112,'Asia/Katmandu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(113,'Europe/Kiev');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(114,'America/Indiana/Knox');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(115,'America/Knox_IN');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(116,'Asia/Krasnoyarsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(117,'Asia/Kuala_Lumpur');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(118,'Asia/Kuching');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(119,'Asia/Kuwait');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(120,'America/La_Paz');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(121,'America/Lima');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(122,'Europe/Lisbon');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(123,'Europe/Ljubljana');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(124,'Europe/London');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(125,'America/Los_Angeles');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(126,'America/Kentucky/Louisville');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(127,'Europe/Luxembourg');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(128,'Asia/Macao');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(129,'America/Maceio');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(130,'Europe/Madrid');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(131,'Asia/Magadan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(132,'Europe/Malta');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(133,'America/Managua');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(134,'America/Manaus');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(135,'Asia/Manila');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(136,'America/Indiana/Marengo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(137,'America/Martinique');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(138,'America/Mazatlan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(139,'America/Argentina/Mendoza');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(140,'America/Menominee');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(141,'America/Merida');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(142,'America/Mexico_City');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(143,'Europe/Minsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(144,'America/Miquelon');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(145,'Europe/Monaco');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(146,'America/Monterrey');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(147,'America/Montevideo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(148,'America/Kentucky/Monticello');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(149,'America/Montreal');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(150,'America/Montserrat');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(151,'Europe/Moscow');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(152,'Asia/Muscat');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(153,'America/Nassau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(154,'America/New_York');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(155,'Europe/Nicosia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(156,'America/Nipigon');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(157,'America/Nome');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(158,'America/Noronha');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(159,'America/North_Dakota/Center');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(160,'Asia/Novosibirsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(161,'Asia/Omsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(162,'Europe/Oslo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(163,'America/Panama');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(164,'America/Pangnirtung');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(165,'America/Paramaribo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(166,'Europe/Paris');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(167,'Asia/Phnom_Penh');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(168,'America/Phoenix');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(169,'Asia/Pontianak');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(170,'America/Port-au-Prince');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(171,'America/Port_of_Spain');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(172,'America/Porto_Acre');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(173,'America/Porto_Velho');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(174,'Europe/Prague');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(175,'America/Puerto_Rico');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(176,'Asia/Pyongyang');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(177,'Asia/Qatar');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(178,'America/Rainy_River');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(179,'Asia/Rangoon');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(180,'America/Rankin_Inlet');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(181,'America/Recife');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(182,'America/Regina');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(183,'Europe/Riga');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(184,'America/Rio_Branco');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(185,'Asia/Riyadh');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(186,'Europe/Rome');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(187,'America/Rosario');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(188,'Asia/Saigon');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(189,'Asia/Sakhalin');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(190,'Europe/Samara');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(191,'Asia/Samarkand');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(192,'Europe/San_Marino');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(193,'America/Santiago');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(194,'America/Santo_Domingo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(195,'America/Sao_Paulo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(196,'Europe/Sarajevo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(197,'America/Scoresbysund');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(198,'Asia/Seoul');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(199,'Asia/Shanghai');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(200,'America/Shiprock');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(201,'Europe/Simferopol');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(202,'Asia/Singapore');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(203,'Europe/Skopje');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(204,'Europe/Sofia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(205,'America/St_Johns');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(206,'America/St_Kitts');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(207,'America/St_Lucia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(208,'America/St_Thomas');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(209,'America/St_Vincent');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(210,'Europe/Stockholm');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(211,'America/Swift_Current');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(212,'Asia/Taipei');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(213,'Europe/Tallinn');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(214,'Asia/Tashkent');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(215,'Asia/Tbilisi');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(216,'America/Tegucigalpa');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(217,'Asia/Tehran');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(218,'Asia/Tel_Aviv');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(219,'Asia/Thimbu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(220,'Asia/Thimphu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(221,'America/Thule');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(222,'America/Thunder_Bay');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(223,'America/Tijuana');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(224,'Europe/Tirane');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(225,'Europe/Tiraspol');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(226,'Asia/Tokyo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(227,'America/Tortola');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(228,'Asia/Ujung_Pandang');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(229,'Asia/Ulaanbaatar');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(230,'Asia/Ulan_Bator');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(231,'Asia/Urumqi');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(232,'Europe/Uzhgorod');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(233,'Europe/Vaduz');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(234,'America/Vancouver');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(235,'Europe/Vatican');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(236,'America/Indiana/Vevay');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(237,'Europe/Vienna');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(238,'Asia/Vientiane');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(239,'Europe/Vilnius');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(240,'America/Virgin');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(241,'Asia/Vladivostok');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(242,'Europe/Warsaw');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(243,'America/Whitehorse');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(244,'America/Winnipeg');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(245,'America/Yakutat');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(246,'Asia/Yakutsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(247,'Asia/Yekaterinburg');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(248,'America/Yellowknife');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(249,'Asia/Yerevan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(250,'Europe/Zagreb');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(251,'Europe/Zaporozhye');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(252,'Europe/Zurich');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(253,'Europe/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(254,'Europe/Volgograd');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(255,'Europe/Jersey');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(256,'Europe/Guernsey');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(257,'Europe/Isle_of_Man');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(258,'Europe/Mariehamn');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(259,'Europe/Podgorica');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(260,'US/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(261,'US/Pacific-New');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(262,'US/Alaska');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(263,'US/Aleutian');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(264,'US/Arizona');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(265,'US/Central');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(266,'US/East-Indiana');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(267,'US/Eastern');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(268,'US/Hawaii');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(269,'US/Indiana-Starke');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(270,'US/Michigan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(271,'US/Mountain');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(272,'US/Pacific');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(273,'US/Samoa');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(274,'America/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(275,'America/North_Dakota/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(276,'America/North_Dakota/New_Salem');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(277,'America/North_Dakota/Beulah');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(278,'America/Sitka');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(279,'America/Metlakatla');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(280,'America/Indiana/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(281,'America/Indiana/Vincennes');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(282,'America/Indiana/Tell_City');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(283,'America/Indiana/Petersburg');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(284,'America/Indiana/Winamac');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(285,'America/Kentucky/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(286,'America/Moncton');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(287,'America/Blanc-Sablon');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(288,'America/Toronto');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(289,'America/Atikokan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(290,'America/Resolute');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(291,'America/Matamoros');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(292,'America/Ojinaga');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(293,'America/Bahia_Banderas');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(294,'America/Santa_Isabel');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(295,'America/Argentina/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(296,'America/Argentina/Salta');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(297,'America/Argentina/Tucuman');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(298,'America/Argentina/La_Rioja');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(299,'America/Argentina/San_Juan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(300,'America/Argentina/San_Luis');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(301,'America/Argentina/Rio_Gallegos');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(302,'America/Argentina/Ushuaia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(303,'America/Argentina/ComodRivadavia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(304,'America/Santarem');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(305,'America/Bahia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(306,'America/Campo_Grande');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(307,'America/St_Barthelemy');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(308,'America/Marigot');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(309,'America/Lower_Princes');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(310,'America/Kralendijk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(311,'America/Buenos_Aires');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(312,'America/Catamarca');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(313,'America/Coral_Harbour');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(314,'America/Cordoba');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(315,'America/Indianapolis');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(316,'America/Jujuy');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(317,'America/Louisville');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(318,'America/Mendoza');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(319,'Asia/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(320,'Asia/Macau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(321,'Asia/Nicosia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(322,'Asia/Kolkata');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(323,'Asia/Makassar');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(324,'Asia/Qyzylorda');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(325,'Asia/Oral');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(326,'Asia/Kathmandu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(327,'Asia/Hebron');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(328,'Asia/Ho_Chi_Minh');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(329,'Asia/Novokuznetsk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(330,'Asia/Riyadh87');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(331,'Asia/Riyadh88');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(332,'Asia/Riyadh89');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(333,'Asia/Istanbul');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(334,'Asia/Ashkhabad');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(335,'Africa/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(336,'Africa/Algiers');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(337,'Africa/Luanda');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(338,'Africa/Porto-Novo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(339,'Africa/Gaborone');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(340,'Africa/Ouagadougou');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(341,'Africa/Bujumbura');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(342,'Africa/Douala');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(343,'Africa/Bangui');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(344,'Africa/Ndjamena');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(345,'Africa/Kinshasa');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(346,'Africa/Lubumbashi');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(347,'Africa/Brazzaville');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(348,'Africa/Abidjan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(349,'Africa/Djibouti');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(350,'Africa/Cairo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(351,'Africa/Malabo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(352,'Africa/Asmara');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(353,'Africa/Addis_Ababa');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(354,'Africa/Libreville');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(355,'Africa/Banjul');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(356,'Africa/Accra');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(357,'Africa/Conakry');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(358,'Africa/Bissau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(359,'Africa/Nairobi');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(360,'Africa/Maseru');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(361,'Africa/Monrovia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(362,'Africa/Tripoli');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(363,'Africa/Blantyre');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(364,'Africa/Bamako');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(365,'Africa/Nouakchott');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(366,'Africa/Casablanca');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(367,'Africa/El_Aaiun');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(368,'Africa/Maputo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(369,'Africa/Windhoek');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(370,'Africa/Niamey');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(371,'Africa/Lagos');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(372,'Africa/Kigali');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(373,'Africa/Sao_Tome');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(374,'Africa/Dakar');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(375,'Africa/Freetown');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(376,'Africa/Mogadishu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(377,'Africa/Johannesburg');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(378,'Africa/Khartoum');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(379,'Africa/Juba');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(380,'Africa/Mbabane');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(381,'Africa/Dar_es_Salaam');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(382,'Africa/Lome');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(383,'Africa/Tunis');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(384,'Africa/Kampala');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(385,'Africa/Lusaka');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(386,'Africa/Harare');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(387,'Africa/Ceuta');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(388,'Africa/Asmera');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(389,'Africa/Timbuktu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(390,'Atlantic/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(391,'Atlantic/Cape_Verde');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(392,'Atlantic/St_Helena');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(393,'Atlantic/Faroe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(394,'Atlantic/Reykjavik');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(395,'Atlantic/Azores');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(396,'Atlantic/Madeira');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(397,'Atlantic/Canary');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(398,'Atlantic/Bermuda');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(399,'Atlantic/Stanley');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(400,'Atlantic/South_Georgia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(401,'Atlantic/Faeroe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(402,'Atlantic/Jan_Mayen');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(403,'Australia/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(404,'Australia/Darwin');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(405,'Australia/Perth');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(406,'Australia/Eucla');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(407,'Australia/Brisbane');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(408,'Australia/Lindeman');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(409,'Australia/Adelaide');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(410,'Australia/Hobart');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(411,'Australia/Currie');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(412,'Australia/Melbourne');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(413,'Australia/Sydney');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(414,'Australia/Broken_Hill');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(415,'Australia/Lord_Howe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(416,'Australia/ACT');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(417,'Australia/Canberra');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(418,'Australia/LHI');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(419,'Australia/NSW');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(420,'Australia/North');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(421,'Australia/Queensland');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(422,'Australia/South');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(423,'Australia/Tasmania');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(424,'Australia/Victoria');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(425,'Australia/West');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(426,'Australia/Yancowinna');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(427,'Indian/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(428,'Indian/Comoro');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(429,'Indian/Antananarivo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(430,'Indian/Mauritius');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(431,'Indian/Mayotte');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(432,'Indian/Reunion');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(433,'Indian/Mahe');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(434,'Indian/Kerguelen');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(435,'Indian/Chagos');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(436,'Indian/Maldives');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(437,'Indian/Christmas');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(438,'Indian/Cocos');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(439,'Pacific/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(440,'Pacific/Rarotonga');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(441,'Pacific/Fiji');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(442,'Pacific/Gambier');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(443,'Pacific/Marquesas');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(444,'Pacific/Tahiti');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(445,'Pacific/Guam');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(446,'Pacific/Tarawa');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(447,'Pacific/Enderbury');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(448,'Pacific/Kiritimati');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(449,'Pacific/Saipan');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(450,'Pacific/Majuro');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(451,'Pacific/Kwajalein');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(452,'Pacific/Chuuk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(453,'Pacific/Pohnpei');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(454,'Pacific/Kosrae');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(455,'Pacific/Nauru');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(456,'Pacific/Noumea');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(457,'Pacific/Auckland');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(458,'Pacific/Chatham');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(459,'Pacific/Niue');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(460,'Pacific/Norfolk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(461,'Pacific/Palau');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(462,'Pacific/Port_Moresby');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(463,'Pacific/Pitcairn');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(464,'Pacific/Pago_Pago');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(465,'Pacific/Apia');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(466,'Pacific/Guadalcanal');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(467,'Pacific/Fakaofo');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(468,'Pacific/Tongatapu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(469,'Pacific/Funafuti');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(470,'Pacific/Johnston');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(471,'Pacific/Midway');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(472,'Pacific/Wake');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(473,'Pacific/Efate');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(474,'Pacific/Wallis');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(475,'Pacific/Honolulu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(476,'Pacific/Easter');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(477,'Pacific/Galapagos');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(478,'Pacific/Samoa');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(479,'Pacific/Yap');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(480,'Pacific/Truk');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(481,'Pacific/Ponape');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(482,'Etc/');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(483,'Etc/GMT');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(484,'Etc/UTC');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(485,'Etc/UCT');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(486,'Etc/GMT-14');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(487,'Etc/GMT-13');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(488,'Etc/GMT-12');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(489,'Etc/GMT-11');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(490,'Etc/GMT-10');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(491,'Etc/GMT-9');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(492,'Etc/GMT-8');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(493,'Etc/GMT-7');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(494,'Etc/GMT-6');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(495,'Etc/GMT-5');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(496,'Etc/GMT-4');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(497,'Etc/GMT-3');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(498,'Etc/GMT-2');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(499,'Etc/GMT-1');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(500,'Etc/GMT+1');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(501,'Etc/GMT+2');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(502,'Etc/GMT+3');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(503,'Etc/GMT+4');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(504,'Etc/GMT+5');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(505,'Etc/GMT+6');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(506,'Etc/GMT+7');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(507,'Etc/GMT+8');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(508,'Etc/GMT+9');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(509,'Etc/GMT+10');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(510,'Etc/GMT+11');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(511,'Etc/GMT+12');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(512,'Etc/Universal');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(513,'Etc/Zulu');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(514,'Etc/Greenwich');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(515,'Etc/GMT-0');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(516,'Etc/GMT+0');
    INSERT INTO TimeZone (TimeZoneID, Name) VALUES(517,'Etc/GMT0');
 

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: TimeZone

March 25, 2025

Contributed by:

Table: TimeZone

How to create

How to initialize

In this article