DECLARE @Timezones TABLE( timezone CHAR(6), Place VARCHAR(30)) INSERT INTO @Timezones (timezone, Place) VALUES ('-12:00', 'Eniwetok'), ('-12:00', 'Kwajalein'), ('-11:00', 'Midway Island'), ('-11:00', 'Samoa'), ('-11:00', 'Pago Pago'), ('-10:00', 'Hawaii'), ('-10:00', 'Honolulu'), ('-09:00', 'Alaska'), ('-09:00', 'Anchorage'), ('-08:00', 'Los Angeles'), ('-08:00', 'Pacific Time (US & Canada)'), ('-08:00', 'San Francisco'), ('-08:00', 'Tijuana'), ('-08:00', 'Vancouver'), ('-07:00', 'Arizona'), ('-07:00', 'Denver'), ('-07:00', 'Mountain Time (US & Canada)'), ('-06:00', 'Central Time (US & Canada)'), ('-06:00', 'Chicago'), ('-06:00', 'Mexico City'), ('-06:00', 'Saskatchewan'), ('-05:00', 'Bogota'), ('-05:00', 'Eastern Time (US & Canada)'), ('-05:00', 'Indiana (East)'), ('-05:00', 'Lima'), ('-05:00', 'Montreal'), ('-05:00', 'New York'), ('-04:00', 'Atlantic Time (Canada)'), ('-04:00', 'Caracas'), ('-04:00', 'La Paz'), ('-04:00', 'Santiago'), ('-03:30', 'Newfoundland'), ('-03:00', 'Brasilia'), ('-03:00', 'Buenos Aires'), ('-03:00', 'Georgetown'), ('-03:00', 'Rio De Janeiro'), ('-02:00', 'Mid-Atlantic'), ('-01:00', 'Azores'), ('-01:00', 'Cape Verde Is.'), ('-00:00', 'Casablanca'), ('-00:00', 'Dublin'), ('-00:00', 'Edinburgh'), ('-00:00', 'Greenwich Mean Time'), ('-00:00', 'Lisbon'), ('-00:00', 'London'), ('-00:00', 'Monrovia'), ('+01:00', 'Amsterdam'), ('+01:00', 'Berlin'), ('+01:00', 'Bern'), ('+01:00', 'Bratislava'), ('+01:00', 'Brussels'), ('+01:00', 'Geneva'), ('+01:00', 'Madrid'), ('+01:00', 'Paris'), ('+01:00', 'Prague'), ('+01:00', 'Rome'), ('+01:00', 'Stockholm'), ('+01:00', 'Vienna'), ('+01:00', 'Warsaw'), ('+02:00', 'Athens'), ('+02:00', 'Cairo'), ('+02:00', 'Eastern Europe'), ('+02:00', 'Harare'), ('+02:00', 'Helsinki'), ('+02:00', 'Israel'), ('+02:00', 'Istanbul'), ('+02:00', 'Pretoria'), ('+03:00', 'Baghdad'), ('+03:00', 'Kuwait'), ('+03:00', 'Moscow'), ('+03:00', 'Nairobi'), ('+03:00', 'Riyadh'), ('+03:00', 'St. Petersburg'), ('+03:30', 'Tehran'), ('+04:00', 'Abu Dhabi'), ('+04:00', 'Dubai'), ('+04:00', 'Kazan'), ('+04:00', 'Muscat'), ('+04:00', 'Tbilisi'), ('+04:00', 'Volgograd'), ('+04:30', 'Kabul'), ('+05:00', 'Ekaterinburg'), ('+05:00', 'Islamabad'), ('+05:00', 'Karachi'), ('+05:00', 'Tashkent'), ('+05:30', 'Bombay'), ('+05:30', 'Calcutta'), ('+05:30', 'Colombo'), ('+05:30', 'Madras'), ('+05:30', 'New Delhi'), ('+06:00', 'Almaty'), ('+06:00', 'Dhaka'), ('+06:30', 'Rangoon'), ('+07:00', 'Bangkok'), ('+07:00', 'Hanoi'), ('+07:00', 'Jakarta'), ('+08:00', 'Beijing'), ('+08:00', 'Chongqing'), ('+08:00', 'Hong Kong'), ('+08:00', 'Manila'), ('+08:00', 'Perth'), ('+08:00', 'Singapore'), ('+08:00', 'Taipei'), ('+08:00', 'Urumqi'), ('+09:00', 'Osaka'), ('+09:00', 'Sapporo'), ('+09:00', 'Seoul'), ('+09:00', 'Tokyo'), ('+09:00', 'Yakutsk'), ('+09:30', 'Adelaide'), ('+09:30', 'Darwin'), ('+10:00', 'Agana'), ('+10:00', 'Brisbane'), ('+10:00', 'Canberra'), ('+10:00', 'Guam'), ('+10:00', 'Hobart'), ('+10:00', 'Melbourne'), ('+10:00', 'Port Moresby'), ('+10:00', 'Sydney'), ('+10:00', 'Vladivostok'), ('+11:00', 'Magadan'), ('+11:00', 'New Caledonia'), ('+11:00', 'Noumea'), ('+11:00', 'Solomon Is.'), ('+12:00', 'Auckland'), ('+12:00', 'Fiji'), ('+12:00', 'Kamchatka'), ('+12:00', 'Marshall Is.'), ('+12:00', 'Suva'), ('+12:00', 'Wellington') SELECT Place, CONVERT(CHAR(20), SWITCHOFFSET(SYSDATETIMEOFFSET( ), timezone), 113) FROM @timezones ORDER BY place