RE: Time Zone Select

Sean Daniels Mon, 02 Oct 2000 15:09:14 -0700
Thank you very much, this will work beautifully.

By the way, I liked the map suggestion too, but not practical for the GUI
implementation. Thanks.


- Sean

~~~~~~~~~~~~~~~~~~~~~~~~~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~~~~~~~~~~~~~~~~~~~~~~~~~
  http://www.dealforce.com
  http://www.mergernetwork.com



> -----Original Message-----
> From: Jaime Garza [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 02, 2000 1:54 PM
> To: CF-Talk
> Subject: RE: Time Zone Select
>
>
> Long one, but here it goes.  SQL server compliant.  Missing
> Daylight Saving
> Times.
>
> CREATE TABLE DirTimeZone (
>       TimeZoneID int IDENTITY (1, 1) NOT NULL ,
>       Name varchar (50) NULL ,
>       Offset varchar (50) NULL
> )
> GO
>
> insert into DirTimeZone (Name, Offset)
> values ('ACT', 'GMT+09:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('AET', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Abidjan', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Accra', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Addis_Ababa', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Algiers', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Asmera', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Bangui', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Banjul', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Bissau', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Blantyre', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Bujumbura', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Cairo', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Casablanca', 'Greenwich Mean Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Conakry', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Dakar', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Dar_es_Salaam', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Djibouti', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Douala', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Freetown', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Gaborone', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Harare', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Johannesburg', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Kampala', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Khartoum', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Kigali', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Kinshasa', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Lagos', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Libreville', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Lome', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Luanda', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Lubumbashi', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Lusaka', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Malabo', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Maputo', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Maseru', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Mbabane', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Mogadishu', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Monrovia', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Nairobi', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Ndjamena', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Niamey', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Nouakchott', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Ouagadougou', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Porto-Novo', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Sao_Tome', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Timbuktu', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Tripoli', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Tunis', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Africa/Windhoek', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('AGT', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Adak', 'GMT-10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Anchorage', 'Alaska Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Anguilla', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Antigua', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Aruba', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Asuncion', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Barbados', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Belize', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Bogota', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Buenos_Aires', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Caracas', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Cayenne', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Cayman', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Chicago', 'Central Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Costa_Rica', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Cuiaba', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Curacao', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Dawson_Creek', 'GMT-07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Denver', 'Mountain Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Dominica', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Edmonton', 'GMT-07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/El_Salvador', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Fortaleza', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Godthab', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Grand_Turk', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Grenada', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Guadeloupe', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Guatemala', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Guayaquil', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Guyana', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Halifax', 'Atlantic Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Havana', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Indianapolis', 'Eastern Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Jamaica', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/La_Paz', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Lima', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Los_Angeles', 'Pacific Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Managua', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Manaus', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Martinique', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Mazatlan', 'GMT-07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Mexico_City', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Miquelon', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Montevideo', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Montreal', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Montserrat', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Nassau', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/New_York', 'Eastern Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Noronha', 'GMT-02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Panama', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Paramaribo', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Phoenix', 'Mountain Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Port-au-Prince', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Port_of_Spain', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Porto_Acre', 'GMT-05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Puerto_Rico', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Regina', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Santiago', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Santo_Domingo', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Sao_Paulo', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Scoresbysund', 'GMT-01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/St_Johns', 'Newfoundland Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/St_Kitts', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/St_Lucia', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/St_Thomas', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/St_Vincent', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Tegucigalpa', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Thule', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Tijuana', 'GMT-08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Tortola', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Vancouver', 'GMT-08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('America/Winnipeg', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Antarctica/Casey', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Antarctica/DumontDUrville', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Antarctica/Mawson', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Antarctica/McMurdo', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Antarctica/Palmer', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('ART', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Aden', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Alma-Ata', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Amman', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Anadyr', 'GMT+13:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Aqtau', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Aqtobe', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Ashkhabad', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Baghdad', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Bahrain', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Baku', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Bangkok', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Beirut', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Bishkek', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Brunei', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Calcutta', 'GMT+05:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Colombo', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Dacca', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Damascus', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Dubai', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Dushanbe', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Hong_Kong', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Irkutsk', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Ishigaki', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Jakarta', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Jayapura', 'GMT+09:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Jerusalem', 'Israel Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Kabul', 'GMT+04:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Kamchatka', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Karachi', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Katmandu', 'GMT+05:45')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Krasnoyarsk', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Kuala_Lumpur', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Kuwait', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Macao', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Magadan', 'GMT+11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Manila', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Muscat', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Nicosia', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Novosibirsk', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Phnom_Penh', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Pyongyang', 'GMT+09:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Qatar', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Rangoon', 'GMT+06:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Riyadh', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Saigon', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Seoul', 'GMT+09:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Shanghai', 'China Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Singapore', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Taipei', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Tashkent', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Tbilisi', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Tehran', 'GMT+03:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Thimbu', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Tokyo', 'Japan Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Ujung_Pandang', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Ulan_Bator', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Vientiane', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Vladivostok', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Yakutsk', 'GMT+09:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Yekaterinburg', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Asia/Yerevan', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('AST', 'Alaska Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Azores', 'GMT-01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Bermuda', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Canary', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Cape_Verde', 'GMT-01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Faeroe', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Jan_Mayen', 'GMT-01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Reykjavik', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/South_Georgia', 'GMT-02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/St_Helena', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Atlantic/Stanley', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Australia/Adelaide', 'GMT+09:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Australia/Brisbane', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Australia/Darwin', 'GMT+09:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Australia/Lord_Howe', 'GMT+10:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Australia/Perth', 'GMT+08:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Australia/Sydney', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('BET', 'GMT-03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('BST', 'GMT+06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('CAT', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('CNT', 'Newfoundland Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('CST', 'Central Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('CTT', 'China Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('EAT', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('ECT', 'Central European Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('EET', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('EST', 'Eastern Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Amsterdam', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Andorra', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Athens', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Belgrade', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Berlin', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Brussels', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Bucharest', 'Eastern European Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Budapest', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Chisinau', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Copenhagen', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Dublin', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Gibraltar', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Helsinki', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Istanbul', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Kaliningrad', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Kiev', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Lisbon', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/London', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Luxembourg', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Madrid', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Malta', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Minsk', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Monaco', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Moscow', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Oslo', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Paris', 'Central European Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Prague', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Riga', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Rome', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Samara', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Simferopol', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Sofia', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Stockholm', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Tallinn', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Tirane', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Vaduz', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Vienna', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Vilnius', 'GMT+02:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Warsaw', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Europe/Zurich', 'GMT+01:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('GMT', 'Greenwich Mean Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('HST', 'Hawaii Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('IET', 'Eastern Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Antananarivo', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Chagos', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Christmas', 'GMT+07:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Cocos', 'GMT+06:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Comoro', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Kerguelen', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Mahe', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Maldives', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Mauritius', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Mayotte', 'GMT+03:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Indian/Reunion', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('IST', 'GMT+05:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('JST', 'Japan Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('MET', 'GMT+03:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('MIT', 'GMT-11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('MST', 'Mountain Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('NET', 'GMT+04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('NST', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Apia', 'GMT-11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Auckland', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Chatham', 'GMT+12:45')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Easter', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Efate', 'GMT+11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Enderbury', 'GMT+13:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Fakaofo', 'GMT-10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Fiji', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Funafuti', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Galapagos', 'GMT-06:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Gambier', 'GMT-09:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Guadalcanal', 'GMT+11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Guam', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Honolulu', 'Hawaii Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Kiritimati', 'GMT+14:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Kosrae', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Majuro', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Marquesas', 'GMT-09:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Nauru', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Niue', 'GMT-11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Norfolk', 'GMT+11:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Noumea', 'GMT+11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Pago_Pago', 'GMT-11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Palau', 'GMT+09:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Pitcairn', 'GMT-08:30')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Ponape', 'GMT+11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Port_Moresby', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Rarotonga', 'GMT-10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Saipan', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Tahiti', 'GMT-10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Tarawa', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Tongatapu', 'GMT+13:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Truk', 'GMT+10:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Wake', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('Pacific/Wallis', 'GMT+12:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('PLT', 'GMT+05:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('PNT', 'Mountain Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('PRT', 'GMT-04:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('PST', 'Pacific Standard Time')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('SST', 'GMT+11:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('UTC', 'GMT+00:00')
> go
>
> insert into DirTimeZone (Name, Offset)
> values ('VST', 'GMT+07:00')
> go
>
> <Jaime/>
>
>
>
> -----Original Message-----
> From: Sean Daniels [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 02, 2000 7:19 AM
> To: CF-Talk
> Subject: Time Zone Select
>
>
> Anyone out there have a custom tag or data table that would allow me to
> easily include a select box for choosing time zone?
>
> TIA
>
>
> - Sean
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
>   Sean Daniels
>   Manager, Engineering
>   (T): 207.439.6030
>   (C): 978.764.0799
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
>   http://www.dealforce.com
>   http://www.mergernetwork.com
>
>
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Time Zone Select

Reply via email to
