Project / Support Center
Welcome, Guest. Please login or register. April 22, 2019, 11:00: PM
Home Help Search Login Register
D-Web Web Site Creator D - Web Web Site Creator On-line HTML Editor No Programming knowledge required. Web Global Net PayPal-Cart Shopping Cart System PayPal - Kart Shopping Cart System for E-Commerce over the internet, that's easy to use. Web Global Net Newsletter Manager Newsletter Manager On-line Newsletter Creator with Email Subscriber Management.
Ring Central Discount
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: mysql Timezone table sql insert 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: mysql Timezone table sql insert  (Read 53 times)
admin
Administrator
******
Offline Offline

Posts: 154


« on: April 08, 2019, 04:01: PM »

-- copy everything from CREATE TABLE downward and use the sql feature with Mysql to create and insert all records listed below into the table.


-- Table structure for table `TimeZone`
--

CREATE TABLE `TimeZone` (
  `timezone_id` int(11) NOT NULL,
  `timezone_GMT_Diff` varchar(11) NOT NULL,
  `timezone_Zone` text NOT NULL,
  `timezone_Area` text NOT NULL,
  `timezone_default_name` text NOT NULL,
  `timezone_flag` text,
  `timezone_note` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TimeZone`
--

INSERT INTO `TimeZone` (`timezone_id`, `timezone_GMT_Diff`, `timezone_Zone`, `timezone_Area`, `timezone_default_name`, `timezone_flag`, `timezone_note`) VALUES
(1, '-11:00', 'Pacific', 'Midway Island ', 'Pacific/Midway', NULL, NULL),
(2, '-11:00', 'Pacific', 'Samoa ', 'Pacific/Samoa', NULL, NULL),
(3, '-10:00', 'Pacific', 'Hawaii ', 'Pacific/Honolulu', NULL, NULL),
(4, '-9:00', 'US', 'Alaska ', 'US/Alaska', NULL, NULL),
(5, '-8:00', 'US', 'Pacific Time  ', 'America/Los_Angeles', NULL, NULL),
(6, '8:00', 'America', 'Tijuana', 'America/Tijuana', NULL, NULL),
(7, '-7:00', 'US', 'Arizona', 'US/Arizona', NULL, NULL),
(8, '-7:00', 'America', 'Chihuahua', 'America/Chihuahua', NULL, NULL),
(9, '-7:00', 'America', 'La Paz ', 'America/Chihuahua', NULL, NULL),
(10, '-7:00', 'America', 'Mazatlan', 'America/Mazatlan', NULL, NULL),
(11, '-7:00', 'US & Canada', 'Mountain Time ', 'US/Mountain', NULL, NULL),
(12, '-6:00', 'America', 'Central America', 'America/Managua', NULL, NULL),
(13, '-6:00', 'US & Canada', 'Central Time  ', 'US/Central', NULL, NULL),
(14, '-6:00', 'America', 'Guadalajara', 'America/Mexico_City', NULL, NULL),
(15, '-6:00', 'Amewrica', 'Mexico City ', 'America/Mexico_City', NULL, NULL),
(16, '-6:00', 'America', 'Monterrey', 'America/Monterrey', NULL, NULL),
(17, '-6:00', 'Canada', 'Saskatchewan', 'Canada/Saskatchewan', NULL, NULL),
(18, '-5:00', 'America', 'Bogota ', 'America/Bogota', NULL, NULL),
(19, '-5:00', 'US & Canada', 'Eastern Time ', 'US/Eastern', NULL, NULL),
(20, '-5:00', 'US', 'Indiana (East)', 'US/East-Indiana', NULL, NULL),
(21, '-5:00', 'America', 'Lima ', 'America/Lima', NULL, NULL),
(22, '-5:00', 'America', 'Quito ', 'America/Bogota', NULL, NULL),
(23, '-4:30', 'America', 'Caracas ', 'America/Caracas', NULL, NULL),
(24, '-4:00', 'Canada', 'Atlantic Time (Canada) ', 'Canada/Atlantic', NULL, NULL),
(25, '-4:00', 'America', 'La Paz ', 'America/La_Paz', NULL, NULL),
(26, '-4:00', 'America', 'Santiago', 'America/Santiago', NULL, NULL),
(27, '-3:30', 'Canada', 'Newfoundland', 'Canada/Newfoundland', NULL, NULL),
(28, '-3:00', 'America', 'Brasilia', 'America/Sao_Paulo', NULL, NULL),
(29, '-3:00', 'America', 'Buenos Aires ', 'America/Argentina/Buenos_Aires', NULL, NULL),
(30, '-3:00', 'America', 'Georgetown ', 'America/Argentina/Buenos_Aires', NULL, NULL),
(31, '-3:00', 'America', 'Greenland', 'America/Godthab', NULL, NULL),
(32, '-2:00', 'America', 'Mid-Atlantic', 'America/Noronha', NULL, NULL),
(33, '-1:00', 'Atlantic', 'Azores ', 'Atlantic/Azores', NULL, NULL),
(34, '-1:00', 'Atlantic', 'Cape Verde Is.', 'Atlantic/Cape_Verde', NULL, NULL),
(35, '0:00', 'Africa', 'Casablanca ', 'Africa/Casablanca', NULL, NULL),
(36, '0:00', 'Europe', 'Edinburgh', 'Europe/London', NULL, NULL),
(37, '0:00', 'GMT', 'Greenwich Mean Time : Dublin ', 'Etc/Greenwich', NULL, NULL),
(38, '0:00', 'Europe', 'Lisbon ', 'Europe/Lisbon', NULL, NULL),
(39, '0:00', 'Europe', 'London', 'Europe/London', NULL, NULL),
(40, '0:00', 'Africa', 'Monrovia ', 'Africa/Monrovia', NULL, NULL),
(41, '0:00', 'UTC', 'UTC ', 'UTC', NULL, NULL),
(42, '+1:00', 'Europe', 'Amsterdam ', 'Europe/Amsterdam', NULL, NULL),
(43, '+1:00', 'Europe', 'Belgrade', 'Europe/Belgrade', NULL, NULL),
(44, '+1:00', 'Europe', 'Berlin ', 'Europe/Berlin', NULL, NULL),
(45, '+1:00', 'Europe', 'Bern ', 'Europe/Berlin', NULL, NULL),
(46, '+1:00', 'Europe', 'Bratislava ', 'Europe/Bratislava', NULL, NULL),
(47, '+1:00', 'Europe', 'Brussels ', 'Europe/Brussels', NULL, NULL),
(48, '+1:00', 'Europe', 'Budapest ', 'Europe/Budapest', NULL, NULL),
(49, '+1:00', 'Europe', 'Copenhagen', 'Europe/Copenhagen', NULL, NULL),
(50, '+1:00', 'Europe', 'Ljubljana ', 'Europe/Ljubljana', NULL, NULL),
(51, '+1:00', 'Europe', 'Madrid ', 'Europe/Madrid', NULL, NULL),
(52, '+1:00', 'Europe', 'Paris ', 'Europe/Paris', NULL, NULL),
(53, '+1:00', 'Europe', 'Prague ', 'Europe/Prague', NULL, NULL),
(54, '+1:00', 'Europe', 'Rome ', 'Europe/Rome', NULL, NULL),
(55, '+1:00', 'Europe', 'Sarajevo', 'Europe/Sarajevo', NULL, NULL),
(56, '+1:00', 'Europe', 'Skopje ', 'Europe/Skopje', NULL, NULL),
(57, '+1:00', 'Europe', 'Stockholm ', 'Europe/Stockholm', NULL, NULL),
(58, '+1:00', 'Europe', 'Vienna ', 'Europe/Vienna', NULL, NULL),
(59, '+1:00', 'Europe', 'Warsaw ', 'Europe/Warsaw', NULL, NULL),
(60, '+1:00', 'Europe', 'West Central Africa ', 'Africa/Lagos', NULL, NULL),
(61, '+1:00', 'Europe', 'Zagreb', 'Europe/Zagreb', NULL, NULL),
(62, '+2:00', 'Europe', 'Athens', 'Europe/Athens', NULL, NULL),
(63, '+2:00', 'Europe', 'Bucharest', 'Europe/Bucharest', NULL, NULL),
(64, '+2:00', 'Africa', 'Cairo ', 'Africa/Cairo', NULL, NULL),
(65, '+2:00', 'Africa', 'Harare ', 'Africa/Harare', NULL, NULL),
(66, '+2:00', 'Europe', 'Helsinki ', 'Europe/Helsinki', NULL, NULL),
(67, '+2:00', 'Europe', 'Istanbul ', 'Europe/Istanbul', NULL, NULL),
(68, '+2:00', 'Asia', 'Jerusalem ', 'Asia/Jerusalem', NULL, NULL),
(69, '+2:00', 'Europe', 'Kyiv ', 'Europe/Helsinki', NULL, NULL),
(70, '+2:00', 'Africa', 'Pretoria ', 'Africa/Johannesburg', NULL, NULL),
(71, '+2:00', 'Europe', 'Riga ', 'Europe/Riga', NULL, NULL),
(72, '+2:00', 'Europe', 'Sofia ', 'Europe/Sofia', NULL, NULL),
(73, '+2:00', 'Europe', 'Tallinn', 'Europe/Tallinn', NULL, NULL),
(74, '+2:00', 'Europe', 'Vilnius ', 'Europe/Vilnius', NULL, NULL),
(75, '+3:00', 'Asia', 'Baghdad ', 'Asia/Baghdad', NULL, NULL),
(76, '+3:00', 'Asia', 'Kuwait', 'Asia/Kuwait', NULL, NULL),
(77, '+3:00', 'Europe', 'Minsk ', 'Europe/Minsk', NULL, NULL),
(78, '+3:00', 'Africa', 'Nairobi', 'Africa/Nairobi', NULL, NULL),
(79, '+3:00', 'Asia', 'Riyadh', 'Asia/Riyadh', NULL, NULL),
(80, '+3:00', 'Europe', 'Volgograd ', 'Europe/Volgograd', NULL, NULL),
(81, '+3:30', 'Asia', 'Tehran ', 'Asia/Tehran', NULL, NULL),
(82, '+4:00', 'Asia', 'Abu Dhabi ', 'Asia/Muscat', NULL, NULL),
(83, '+4:00', 'Asia', 'Baku ', 'Asia/Baku', NULL, NULL),
(84, '+4:00', 'Europe', 'Moscow ', 'Europe/Moscow', NULL, NULL),
(85, '+4:00', 'Asia', 'Muscat', 'Asia/Muscat', NULL, NULL),
(86, '+4:00', 'Europe', 'St. Petersburg', 'Europe/Moscow', NULL, NULL),
(87, '+4:00', 'Asia', 'Tbilisi ', 'Asia/Tbilisi', NULL, NULL),
(88, '+4:00', 'Asia', 'Yerevan ', 'Asia/Yerevan', NULL, NULL),
(89, '+4:30', 'Asia', 'Kabul ', 'Asia/Kabul', NULL, NULL),
(90, '+5:00', 'Asia', 'Islamabad', 'Asia/Karachi', NULL, NULL),
(91, '+5:00', 'Asia', 'Karachi ', 'Asia/Karachi', NULL, NULL),
(92, '+5:00', 'Asia', 'Tashkent ', 'Asia/Tashkent', NULL, NULL),
(93, '+5:30', 'Asia', 'Chennai ', 'Asia/Calcutta', NULL, NULL),
(94, '+5:30', 'Asia', 'Kolkata ', 'Asia/Kolkata', NULL, NULL),
(95, '+5:30', 'Asia', 'Mumbai ', 'Asia/Calcutta', NULL, NULL),
(96, '+5:30', 'Asia', 'New Delhi ', 'Asia/Calcutta', NULL, NULL),
(97, '+5:30', 'Asia', 'Sri Jayawardenepura ', 'Asia/Calcutta', NULL, NULL),
(98, '+5:45', 'Asia', 'Kathmandu ', 'Asia/Katmandu', NULL, NULL),
(99, '+6:00', 'Asia', 'Almaty ', 'Asia/Almaty', NULL, NULL),
(100, '+6:00', 'Asia', 'Astana', 'Asia/Dhaka', NULL, NULL),
(101, '+6:00', 'Asia', 'Dhaka ', 'Asia/Dhaka', NULL, NULL),
(102, '+6:00', 'Asia', 'Ekaterinburg ', 'Asia/Yekaterinburg', NULL, NULL),
(103, '+6:30', 'Asia', 'Rangoon ', 'Asia/Rangoon', NULL, NULL),
(104, '+7:00', 'Asia', 'Bangkok ', 'Asia/Bangkok', NULL, NULL),
(105, '+7:00', 'Asia', 'Hanoi', 'Asia/Bangkok', NULL, NULL),
(106, '+7:00', 'Asia', 'Jakarta ', 'Asia/Jakarta', NULL, NULL),
(107, '+7:00', 'Asia', 'Novosibirsk ', 'Asia/Novosibirsk', NULL, NULL),
(108, '+8:00', 'Asia', 'Beijing ', 'Asia/Hong_Kong', NULL, NULL),
(109, '+8:00', 'Asia', 'Chongqing ', 'Asia/Chongqing', NULL, NULL),
(110, '+8:00', 'Asia', 'Hong Kong ', 'Asia/Hong_Kong', NULL, NULL),
(111, '+8:00', 'Asia', 'Krasnoyarsk', 'Asia/Krasnoyarsk', NULL, NULL),
(112, '+8:00', 'Asia', 'Kuala Lumpur ', 'Asia/Kuala_Lumpur', NULL, NULL),
(113, '+8:00', 'Australia', 'Perth ', 'Australia/Perth', NULL, NULL),
(114, '+8:00', 'Asia', 'Singapore ', 'Asia/Singapore', NULL, NULL),
(115, '+8:00', 'Asia', 'Taipei ', 'Asia/Taipei', NULL, NULL),
(116, '+8:00', 'Asia', 'Ulaan Bataar ', 'Asia/Ulan_Bator', NULL, NULL),
(117, '+8:00', 'Asia', 'Urumqi', 'Asia/Urumqi', NULL, NULL),
(118, '+9:00', 'Asia', 'Irkutsk ', 'Asia/Irkutsk', NULL, NULL),
(119, '+9:00', 'Asia', ' Osaka', 'Asia/Tokyo', NULL, NULL),
(120, '+9:00', 'Asia', ' Sapporo ', 'Asia/Tokyo', NULL, NULL),
(121, '+9:00', 'Asia', 'Seoul ', 'Asia/Seoul', NULL, NULL),
(122, '+9:00', 'Asia', 'Tokyo', 'Asia/Tokyo', NULL, NULL),
(123, '+9:30', 'Australia', 'Adelaide', 'Australia/Adelaide', NULL, NULL),
(124, '+9:30', 'Australia', 'Darwin ', 'Australia/Darwin', NULL, NULL),
(125, '+10:00', 'Australia', 'Brisbane ', 'Australia/Brisbane', NULL, NULL),
(126, '+10:00', 'Australia', 'Canberra ', 'Australia/Canberra', NULL, NULL),
(127, '+10:00', 'Pacific', 'Guam ', 'Pacific/Guam', NULL, NULL),
(128, '+10:00', 'Australia', 'Hobart  ', 'Australia/Hobart', NULL, NULL),
(129, '+10:00', 'Australia', 'Melbourne ', 'Australia/Melbourne', NULL, NULL),
(130, '+10:00', 'Pacific', 'Port Moresby ', 'Pacific/Port_Moresby', NULL, NULL),
(131, '+10:00', 'Australia', 'Sydney ', 'Australia/Sydney', NULL, NULL),
(132, '+10:00', 'Asia', 'Yakutsk ', 'Asia/Yakutsk', NULL, NULL),
(133, '+11:00', 'Asia', 'Vladivostok ', 'Asia/Vladivostok', NULL, NULL),
(134, '+12:00', 'Pacific', 'Auckland ', 'Pacific/Auckland', NULL, NULL),
(135, '+12:00', 'Pacific', 'Fiji ', 'Pacific/Fiji', NULL, NULL),
(136, '+12:00', 'Pacific/IDL', 'International Date Line West ', 'Pacific/Kwajalein', NULL, NULL),
(137, '+12:00', 'Asia', 'Kamchatka ', 'Asia/Kamchatka', NULL, NULL),
(138, '+12:00', 'Asia', 'Magadan', 'Asia/Magadan', NULL, NULL),
(139, '+12:00', 'Asia', 'Marshall Is. ', 'Pacific/Fiji', NULL, NULL),
(140, '+12:00', 'Asia', 'New Caledonia ', 'Asia/Magadan', NULL, NULL),
(141, '+12:00', 'Asia', 'Solomon Is.', 'Asia/Magadan', NULL, NULL),
(142, '+12:00', 'Pacific', 'Wellington ', 'Pacific/Auckland', NULL, NULL),
(143, '+13:00', 'Pacific', 'Nuku-alofa ', 'Pacific/Tongatapu', NULL, NULL);
Report to moderator   Logged

The Unknown Webmaster
Pages: [1] Go Up Send this topic Print 
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: mysql Timezone table sql insert « previous next »
Jump to:  


Login with username, password and session length
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!