Page 1 of 1

Time Zones (SQL) w/ examples

Posted: Sun Mar 01, 2015 6:18 pm
by dzcadii
Time Zones SQL
Simply copy that into a file and name it what ever you want. Make sure you put ".sql" as the extension.

Code: Select all

-- Table structure for table `time_zones`
-- 

CREATE TABLE IF NOT EXISTS `time_zones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `GMT_Offset_Name` varchar(100) NOT NULL,
  `GMT_Offset` varchar(15) NOT NULL,
  `Zone` varchar(5) NOT NULL,
  `Military` varchar(25) NOT NULL,
  `Civilian_Time_Zones` longtext NOT NULL,
  `Cities` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

-- 
-- Dumping data for table `time_zones`
-- 

INSERT INTO `time_zones` (`id`, `GMT_Offset_Name`, `GMT_Offset`, `Zone`, `Military`, `Civilian_Time_Zones`, `Cities`) VALUES 
(1, 'Standard Time Zones', '0', 'Z', 'Zulu', 'GMT: Greenwich Mean\r\nUT: Universal\r\nUTC: Universal Co-ordinated\r\nWET: Western European', 'London, England\r\nDublin, Ireland\r\nEdinburgh, Scotland\r\nLisbon, Portugal\r\nReykjavik, Iceland\r\nCasablanca, Morocco'),
(2, 'East of Greenwich', '+1', 'A', 'Alpha', 'CET: Central European', 'Paris, France\r\nBerlin, Germany\r\nAmsterdam, The Netherlands\r\nBrussels, Belgium\r\nVienna, Austria\r\nMadrid, Spain\r\nRome, Italy\r\nBern, Switzerland\r\nStockholm, Sweden\r\nOslo, Norway'),
(3, 'East of Greenwich', '+2', 'B', 'Bravo', 'EET: Eastern European', 'Athens, Greece\r\nHelsinki, Finland\r\nIstanbul, Turkey\r\nJerusalem, Israel\r\nHarare, Zimbabwe'),
(4, 'East of Greenwich', '+3', 'C', 'Charlie', 'BT: Baghdad', 'Kuwait\r\nNairobi, Kenya\r\nRiyadh, Saudi Arabia\r\nMoscow, Russia'),
(5, 'East of Greenwich', '+3.5', 'C*', 'N/A', '', 'Tehran, Iran'),
(6, 'East of Greenwich', '+4', 'D', 'Delta', '', 'Abu Dhabi, UAE\r\nMuscat\r\nTblisi\r\nVolgograd\r\nKabul'),
(7, 'East of Greenwich', '+4.5', 'D*', '', '', 'Afghanistan'),
(8, 'East of Greenwich', '+5', 'E', 'Echo', '', ''),
(9, 'East of Greenwich', '+5.5', 'E*', '', '', 'India'),
(10, 'East of Greenwich', '+6', 'F', 'Foxtrot', '', ''),
(11, 'East of Greenwich', '+6.5', 'F*', '', '', 'Cocos Islands'),
(12, 'East of Greenwich', '+7', 'G', 'Golf', '', ''),
(13, 'East of Greenwich', '+8', 'H', 'Hotel', 'CCT: China Coast', ''),
(14, 'East of Greenwich', '+9', 'I', 'India', 'JST: Japan Standard', ''),
(15, 'East of Greenwich', '+9.5', 'I*', '', 'Australia Central Standard', 'Darwin, Australia\r\nAdelaide, Australia'),
(16, 'East of Greenwich', '+10', 'K', 'Kilo', 'GST: Guam Standard', ''),
(17, 'East of Greenwich', '+10.5', 'K*', '', '', 'Lord Howe Island'),
(18, 'East of Greenwich', '+11', 'L', 'Lima', '', ''),
(19, 'East of Greenwich', '+11.5', 'L*', '', '', 'Norfolk Island'),
(20, 'East of Greenwich', '+12', 'M', 'Mike', 'IDLE: International Date Line East\r\nNZST: New Zealand Standard', 'Wellington, New Zealand\r\nFiji\r\nMarshall Islands'),
(21, 'East of Greenwich', '+13', 'M*', '', '', 'Rawaki Islands: Enderbury Kiribati'),
(22, 'East of Greenwich', '+14', 'M±', '', '', 'Line Islands: Kiritibati'),
(23, 'West of Greenwich', '-1', 'N', 'November', 'WAT: West Africa', 'Azores, Cape Verde Islands'),
(24, 'West of Greenwich', '-2', 'O', 'Oscar', 'AT: Azores', ''),
(25, 'West of Greenwich', '-3', 'P', 'Papa', '', 'Brasilia, Brazil\r\nBuenos Aires, Argentina\r\nGeorgetown, Guyana'),
(26, 'West of Greenwich', '-3.5', 'P*', '', '', 'Newfoundland'),
(27, 'West of Greenwich', '-4', 'Q', 'Qubec', 'AST: Atlantic Standard', 'Caracas\r\nLa Paz'),
(28, 'West of Greenwich', '-5', 'R', 'Romeo', 'EST: Eastern Standard', 'Bogota\r\nLima, Peru\r\nNew York, NY, USA'),
(29, 'West of Greenwich', '-6', 'S', 'Sierra', 'CST: Central Standard', 'Mexico City, Mexico\r\nSaskatchewan, Canada'),
(30, 'West of Greenwich', '-7', 'T', 'Tango', 'MST: Mountain Standard', ''),
(31, 'West of Greenwich', '-8', 'U', 'Uniform', 'PST: Pacific Standard', 'Los Angeles, CA, USA'),
(32, 'West of Greenwich', '-8.5', 'U*', '', '', ''),
(33, 'West of Greenwich', '-9', 'V', 'Victor', 'YST:  Yukon Standard', ''),
(34, 'West of Greenwich', '-9.5', 'V*', '', '', ''),
(35, 'West of Greenwich', '-10', 'W', 'Whiskey', 'AHST: Alaska-Hawaii Standard\r\nCAT: Central Alaska\r\nHST: Hawaii Standard', ''),
(36, 'West of Greenwich', '-11', 'X', 'X-ray', 'NT: Nome', ''),
(37, 'West of Greenwich', '-12', 'Y', 'Yankee', 'IDLW: International Date Line West', '');