Friday, December 4, 2009

Timezone List in MySQL

Below you can find a list of all timezones and their offsets.

CREATE TABLE IF NOT EXISTS `time_zone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `offset` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

INSERT INTO `time_zone` (`id`, `name`, `offset`) VALUES
(1, '(-12:00) Enitwetok, Kwajalien', -12),
(2, '(-11:00) Midway Island, Samoa', -11),
(3, '(-10:00) Hawaii', -10),
(4, '(-9:30) French Polynesia', -9.5),
(5, '(-9:00) Alaska', -9),
(6, '(-8:00) Pacific Time (US & Canada)', -8),
(7, '(-7:00) Mountain Time (US & Canada)', -7),
(8, '(-6:00) Central Time (US & Canada), Mexico City', -6),
(9, '(-5:00) Eastern Time (US & Canada), Bogota, Lima', -5),
(10, '(-4:00) Atlantic Time (Canada), Caracas, La Paz', -4),
(11, '(-3:30) Newfoundland', -3.5),
(12, '(-3:00) Brazil, Buenos Aires, Falkland Is.', -3),
(13, '(-2:00) Mid-Atlantic, Ascention Is., St Helena', -2),
(14, '(-1:00) Azores, Cape Verde Islands', -1),
(15, 'Casablanca, Dublin, London, Lisbon, Monrovia', 0),
(16, '(+1:00) Brussels, Copenhagen, Madrid, Paris', 1),
(17, '(+2:00) Kaliningrad, South Africa', 2),
(18, '(+3:00) Baghdad, Riyadh, Moscow, Nairobi', 3),
(19, '(+3:30) Tehran', 3.5),
(20, '(+4:00) Abu Dhabi, Baku, Muscat, Tbilisi', 4),
(21, '(+4:30) Kabul', 4.5),
(22, '(+5:00) Ekaterinburg, Karachi, Tashkent', 5),
(23, '(+5:30) Bombay, Calcutta, Madras, New Delhi', 5.5),
(24, '(+5:45) Kathmandu', 5.75),
(25, '(+6:00) Almaty, Colombo, Dhaka', 6),
(26, '(+6:30) Yangon, Naypyidaw, Bantam', 6.5),
(27, '(+7:00) Bangkok, Hanoi, Jakarta', 7),
(28, '(+8:00) Hong Kong, Perth, Singapore, Taipei', 8),
(29, '(+8:45) Caiguna, Eucla', 8.75),
(30, '(+9:00) Osaka, Sapporo, Seoul, Tokyo, Yakutsk', 9),
(31, '(+9:30) Adelaide, Darwin', 9.5),
(32, '(+10:00) Melbourne, Papua New Guinea, Sydney', 10),
(33, '(+10:30) Lord Howe Island', 10.5),
(34, '(+11:00) Magadan, New Caledonia, Solomon Is.', 11),
(35, '(+11:30) Burnt Pine, Kingston', 11.5),
(36, '(+12:00) Auckland, Fiji, Marshall Island', 12),
(37, '(+12:45) Chatham Islands', 12.75),
(38, '(+13:00) Kamchatka, Anadyr', 13),
(39, '(+14:00) Kiritimati', 14);

No comments:

Post a Comment