Here's a timezone drop-down select for HTML ready to copy/paste into your code.
And here is an SQL version of this list:
INSERT INTO timezones (GMT, name) VALUES
('5.0', '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent'),
('4.5', '(GMT +4:30) Kabul'),
('4.0', '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi'),
('3.5', '(GMT +3:30) Tehran'),
('3.0', '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg'),
('2.0', '(GMT +2:00) Kaliningrad, South Africa'),
('1.0', '(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris'),
('-12.0', '(GMT -12:00) Eniwetok, Kwajalein'),
('-11.0', '(GMT -11:00) Midway Island, Samoa'),
('-10.0', '(GMT -10:00) Hawaii'),
('-9.0', '(GMT -9:00) Alaska'),
('-8.0', '(GMT -8:00) Pacific Time (US & Canada)'),
('-7.0', '(GMT -7:00) Mountain Time (US & Canada)'),
('-6.0', '(GMT -6:00) Central Time (US & Canada), Mexico City'),
('-5.0', '(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima'),
('-4.0', '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz'),
('-3.5', '(GMT -3:30) Newfoundland'),
('-3.0', '(GMT -3:00) Brazil, Buenos Aires, Georgetown'),
('-2.0', '(GMT -2:00) Mid-Atlantic'),
('-1.0', '(GMT -1:00 hour) Azores, Cape Verde Islands'),
('0.0', '(GMT) Western Europe Time, London, Lisbon, Casablanca'),
('5.5', '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi'),
('5.75', '(GMT +5:45) Kathmandu'),
('6.0', '(GMT +6:00) Almaty, Dhaka, Colombo'),
('7.0', '(GMT +7:00) Bangkok, Hanoi, Jakarta'),
('8.0', '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong'),
('9.0', '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk'),
('9.5', '(GMT +9:30) Adelaide, Darwin'),
('10.0', '(GMT +10:00) Eastern Australia, Guam, Vladivostok'),
('11.0', '(GMT +11:00) Magadan, Solomon Islands, New Caledonia'),
('12.0', '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka');
And here's a PHP array version
Here's a Ruby on Rails migration version:
create_table :timezones do |t|
t.integer :company_id
t.decimal :GMT, :null => false, :precision => 3, :scale => 1
t.string :name, :null => false
end
add_index :timezones, :GMT, :unique => true
Timezone.create :GMT => 5.0, :name => '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent'
Timezone.create :GMT => 4.5, :name => '(GMT +4:30) Kabul'
Timezone.create :GMT => 4.0, :name => '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi'
Timezone.create :GMT => 3.5, :name => '(GMT +3:30) Tehran'
Timezone.create :GMT => 3.0, :name => '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg'
Timezone.create :GMT => 2.0, :name => '(GMT +2:00) Kaliningrad, South Africa'
Timezone.create :GMT => 1.0, :name => '(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris'
Timezone.create :GMT => -12.0, :name => '(GMT -12:00) Eniwetok, Kwajalein'
Timezone.create :GMT => -11.0, :name => '(GMT -11:00) Midway Island, Samoa'
Timezone.create :GMT => -10.0, :name => '(GMT -10:00) Hawaii'
Timezone.create :GMT => -9.0, :name => '(GMT -9:00) Alaska'
Timezone.create :GMT => -8.0, :name => '(GMT -8:00) Pacific Time (US & Canada)'
Timezone.create :GMT => -7.0, :name => '(GMT -7:00) Mountain Time (US & Canada)'
Timezone.create :GMT => -6.0, :name => '(GMT -6:00) Central Time (US & Canada), Mexico City'
Timezone.create :GMT => -5.0, :name => '(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima'
Timezone.create :GMT => -4.0, :name => '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz'
Timezone.create :GMT => -3.5, :name => '(GMT -3:30) Newfoundland'
Timezone.create :GMT => -3.0, :name => '(GMT -3:00) Brazil, Buenos Aires, Georgetown'
Timezone.create :GMT => -2.0, :name => '(GMT -2:00) Mid-Atlantic'
Timezone.create :GMT => -1.0, :name => '(GMT -1:00 hour) Azores, Cape Verde Islands'
Timezone.create :GMT => 0.0, :name => '(GMT) Western Europe Time, London, Lisbon, Casablanca'
Timezone.create :GMT => 5.5, :name => '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi'
Timezone.create :GMT => 5.75, :name => '(GMT +5:45) Kathmandu'
Timezone.create :GMT => 6.0, :name => '(GMT +6:00) Almaty, Dhaka, Colombo'
Timezone.create :GMT => 7.0, :name => '(GMT +7:00) Bangkok, Hanoi, Jakarta'
Timezone.create :GMT => 8.0, :name => '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong'
Timezone.create :GMT => 9.0, :name => '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk'
Timezone.create :GMT => 9.5, :name => '(GMT +9:30) Adelaide, Darwin'
Timezone.create :GMT => 10.0, :name => '(GMT +10:00) Eastern Australia, Guam, Vladivostok'
Timezone.create :GMT => 11.0, :name => '(GMT +11:00) Magadan, Solomon Islands, New Caledonia'
Timezone.create :GMT => 12.0, :name => '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka'
end
posted on 2012-06-01 00:00:00 UTC
| Topic | Sandbox |
|---|---|
| Tags | Html, Snippits |