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.
