PHPology is a collective of highly skilled, award winning, web gurus.
Contact Raj on 07985 467 213 or email [email protected]

General timezone list for MYSQL

Today I had to create short list of timezones for a project I was working on and basically created a list that I used within a MYSQL database, which I hope saves someone else the hassle. Once in database, it can be used in selectlists using PHP, etc.

CREATE TABLE IF NOT EXISTS 'tbl_timezone' (
  'timezone_id' int(11) NOT NULL AUTO_INCREMENT,
  'description' varchar(100) NOT NULL,
  'shift' decimal(4,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY ('timezone_id')
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;

INSERT INTO 'tbl_timezone' ('timezone_id', 'description', 'shift') VALUES
(1, '(GMT -12:00) Eniwetok, Kwajalein', '-12.00'),
(2, '(GMT -11:00) Midway Island, Samoa', '-11.00'),
(3, '(GMT -10:00) Hawaii', '-10.00'),
(4, '(GMT -9:00) Alaska', '-9.00'),
(5, '(GMT -8:00) Pacific Time (US & Canada)', '-8.00'),
(6, '(GMT -7:00) Mountain Time (US & Canada)', '-7.00'),
(7, '(GMT -6:00) Central Time (US & Canada), Mexico City', '-6.00'),
(8, '(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima', '-5.00'),
(9, '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz', '-4.00'),
(10, '(GMT -3:30) Newfoundland', '-3.30'),
(11, '(GMT -3:00) Brazil, Buenos Aires, Georgetown', '-3.00'),
(12, '(GMT -2:00) Mid-Atlantic', '-2.00'),
(13, '(GMT -1:00 hour) Azores, Cape Verde Islands', '-1.00'),
(14, '(GMT) Western Europe Time, London, Lisbon, Casablanca', '0.00'),
(15, '(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris', '1.00'),
(16, '(GMT +2:00) Kaliningrad, South Africa', '2.00'),
(17, '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg', '3.00'),
(18, '(GMT +3:30) Tehran', '3.30'),
(19, '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi', '4.00'),
(20, '(GMT +4:30) Kabul', '4.30'),
(21, '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent', '5.00'),
(22, '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi', '5.30'),
(23, '(GMT +5:45) Kathmandu', '5.45'),
(24, '(GMT +6:00) Almaty, Dhaka, Colombo', '6.00'),
(25, '(GMT +7:00) Bangkok, Hanoi, Jakarta', '7.00'),
(26, '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong', '8.00'),
(27, '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk', '9.00'),
(28, '(GMT +9:30) Adelaide, Darwin', '9.30'),
(29, '(GMT +10:00) Eastern Australia, Guam, Vladivostok', '10.00'),
(30, '(GMT +11:00) Magadan, Solomon Islands, New Caledonia', '11.00'),
(31, '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka', '12.00');