Timezones, HTML select drop-down, SQL to insert into database

 

Here's a timezone drop-down select for HTML ready to copy/paste into your code.

<select name="timezone" id="ddtz"> <option value="-12.0">(GMT -12:00) Eniwetok, Kwajalein</option> <option value="-11.0">(GMT -11:00) Midway Island, Samoa</option> <option value="-10.0">(GMT -10:00) Hawaii</option> <option value="-9.0">(GMT -9:00) Alaska</option> <option value="-8.0">(GMT -8:00) Pacific Time (US & Canada)</option> <option value="-7.0">(GMT -7:00) Mountain Time (US & Canada)</option> <option value="-6.0">(GMT -6:00) Central Time (US & Canada), Mexico City</option> <option value="-5.0">(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima</option> <option value="-4.0">(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz</option> <option value="-3.5">(GMT -3:30) Newfoundland</option> <option value="-3.0">(GMT -3:00) Brazil, Buenos Aires, Georgetown</option> <option value="-2.0">(GMT -2:00) Mid-Atlantic</option> <option value="-1.0">(GMT -1:00 hour) Azores, Cape Verde Islands</option> <option value="0.0">(GMT) Western Europe Time, London, Lisbon, Casablanca</option> <option value="1.0">(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris</option> <option value="2.0">(GMT +2:00) Kaliningrad, South Africa</option> <option value="3.0">(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg</option> <option value="3.5">(GMT +3:30) Tehran</option> <option value="4.0">(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi</option> <option value="4.5">(GMT +4:30) Kabul</option> <option value="5.0">(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent</option> <option value="5.5">(GMT +5:30) Bombay, Calcutta, Madras, New Delhi</option> <option value="5.75">(GMT +5:45) Kathmandu</option> <option value="6.0">(GMT +6:00) Almaty, Dhaka, Colombo</option> <option value="7.0">(GMT +7:00) Bangkok, Hanoi, Jakarta</option> <option value="8.0">(GMT +8:00) Beijing, Perth, Singapore, Hong Kong</option> <option value="9.0">(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk</option> <option value="9.5">(GMT +9:30) Adelaide, Darwin</option> <option value="10.0">(GMT +10:00) Eastern Australia, Guam, Vladivostok</option> <option value="11.0">(GMT +11:00) Magadan, Solomon Islands, New Caledonia</option> <option value="12.0">(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka</option> </select>

And here is an SQL version of this list:

CREATE TABLE <code>timezones</code> ( <code>GMT</code> varchar(6) NOT NULL, <code>name</code> varchar(75) NOT NULL, UNIQUE KEY <code>GMT</code> (<code>GMT</code>) );</p> <p>INSERT INTO <code>timezones</code> (<code>GMT</code>, <code>name</code>) 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

$timeZones = array( '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', );

Here's a Ruby on Rails migration version:

def up</p> <pre><code>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' </code></pre> <p> end

 

posted on 2012-06-01 00:00:00 UTC

Topic	Sandbox
Tags	Html, Snippits

 

---