将Olson TZID转换为Windows时区

我正在寻找一个表,将所有的Olson TZID转换为 Windows时区.我已经发现:

.NET TimeZoneInfo from Olson time zone

哪个是伟大的,可以从以下信息构建:

http://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml

但不幸的是,它只将一些TZID映射到Windows时区.有没有人遇到(或制作)一张桌子?

好的,所以我把一个桌子放在一起.我确信有很多不准确的地方,并且有很多区域不映射,但它现在将为我的目的.我也把表放在以下URL.如有任何修改或补充,请通知我,我会添加/更改.

http://www.snae.net/tzids.csv

更新,以下页面也看起来有很好的信息:http://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml

Olson TZID,UTC Offset,Windows Timezone ID,Windows Display Name
Pacific/Apia,-11,Samoa Standard Time,(UTC-11:00) Samoa
Pacific/Midway,Hawaiian Standard Time,(UTC-10:00) Hawaii
Pacific/Niue,(UTC-11:00) Samoa
Pacific/Pago_Pago,(UTC-11:00) Samoa
America/Adak,-10,(UTC-10:00) Hawaii
Pacific/Fakaofo,(UTC-10:00) Hawaii
Pacific/Honolulu,(UTC-10:00) Hawaii
Pacific/Johnston,(UTC-10:00) Hawaii
Pacific/Rarotonga,(UTC-10:00) Hawaii
Pacific/Tahiti,(UTC-10:00) Hawaii
Pacific/Marquesas,-9.5,(UTC-10:00) Hawaii
America/Anchorage,-9,Alaskan Standard Time,(UTC-09:00) Alaska
America/Juneau,(UTC-09:00) Alaska
America/Nome,(UTC-09:00) Alaska
America/Yakutat,(UTC-09:00) Alaska
Pacific/Gambier,(UTC-09:00) Alaska
America/Dawson,-8,Pacific Standard Time,(UTC-08:00) Pacific Time (US & Canada) 
America/Los_Angeles,(UTC-08:00) Pacific Time (US & Canada) 
America/Santa_Isabel,Pacific Standard Time (Mexico),(UTC-08:00) Baja California
America/Tijuana,(UTC-08:00) Baja California
America/Vancouver,(UTC-08:00) Pacific Time (US & Canada) 
America/Whitehorse,(UTC-08:00) Pacific Time (US & Canada) 
Pacific/Pitcairn,(UTC-08:00) Pacific Time (US & Canada) 
America/Boise,-7,Mountain Standard Time,(UTC-07:00) Mountain Time (US & Canada)
America/Cambridge_Bay,(UTC-07:00) Mountain Time (US & Canada)
America/Chihuahua,Mountain Standard Time (Mexico),"(UTC-07:00) Chihuahua,La Paz,Mazatlan"
America/Dawson_Creek,(UTC-07:00) Mountain Time (US & Canada)
America/Denver,(UTC-07:00) Mountain Time (US & Canada)
America/Edmonton,(UTC-07:00) Mountain Time (US & Canada)
America/Hermosillo,(UTC-07:00) Mountain Time (US & Canada)
America/Inuvik,(UTC-07:00) Mountain Time (US & Canada)
America/Mazatlan,(UTC-07:00) Mountain Time (US & Canada)
America/Ojinaga,US Mountain Standard Time,(UTC-07:00) Arizona
America/Phoenix,(UTC-07:00) Arizona
America/Shiprock,(UTC-07:00) Mountain Time (US & Canada)
America/Yellowknife,(UTC-07:00) Mountain Time (US & Canada)
America/Belize,-6,Central America Standard Time,(UTC-06:00) Central America
America/Cancun,Central Standard Time (Mexico),"(UTC-06:00) Guadalajara,Mexico City,Monterrey"
America/Chicago,Central Standard Time,(UTC-06:00) Central Time (US & Canada)
America/Costa_Rica,(UTC-06:00) Central America
America/El_Salvador,(UTC-06:00) Central America
America/Guatemala,(UTC-06:00) Central America
America/Indiana/Knox,(UTC-06:00) Central Time (US & Canada)
America/Indiana/Tell_City,(UTC-06:00) Central Time (US & Canada)
America/Managua,(UTC-06:00) Central Time (US & Canada)
America/Matamoros,(UTC-06:00) Central Time (US & Canada)
America/Menominee,(UTC-06:00) Central Time (US & Canada)
America/Merida,(UTC-06:00) Central Time (US & Canada)
America/Mexico_City,Monterrey"
America/Monterrey,Monterrey"
America/North_Dakota/Center,(UTC-06:00) Central Time (US & Canada)
America/North_Dakota/New_Salem,(UTC-06:00) Central Time (US & Canada)
America/Rainy_River,(UTC-06:00) Central Time (US & Canada)
America/Rankin_Inlet,(UTC-06:00) Central Time (US & Canada)
America/Regina,(UTC-06:00) Central Time (US & Canada)
America/Swift_Current,(UTC-06:00) Central Time (US & Canada)
America/Tegucigalpa,(UTC-06:00) Central Time (US & Canada)
America/Winnipeg,(UTC-06:00) Central Time (US & Canada)
Pacific/Easter,(UTC-06:00) Central America
Pacific/Galapagos,(UTC-06:00) Central America
America/Atikokan,-5,Eastern Standard Time,(UTC-05:00) Eastern Time (US & Canada)
America/Bogota,SA Pacific Standard Time,"(UTC-05:00) Bogota,Lima,Quito"
America/Cayman,(UTC-05:00) Eastern Time (US & Canada)
America/Detroit,(UTC-05:00) Eastern Time (US & Canada)
America/Grand_Turk,(UTC-05:00) Eastern Time (US & Canada)
America/Guayaquil,(UTC-05:00) Eastern Time (US & Canada)
America/Havana,Quito"
America/Indiana/Indianapolis,US Eastern Standard Time,(UTC-05:00) Indiana (East)
America/Indiana/Marengo,(UTC-05:00) Indiana (East)
America/Indiana/Petersburg,(UTC-05:00) Indiana (East)
America/Indiana/Vevay,(UTC-05:00) Indiana (East)
America/Indiana/Vincennes,(UTC-05:00) Indiana (East)
America/Indiana/Winamac,(UTC-05:00) Indiana (East)
America/Iqaluit,(UTC-05:00) Eastern Time (US & Canada)
America/Jamaica,(UTC-05:00) Eastern Time (US & Canada)
America/Kentucky/Louisville,(UTC-05:00) Eastern Time (US & Canada)
America/Kentucky/Monticello,(UTC-05:00) Eastern Time (US & Canada)
America/Lima,Quito"
America/Montreal,(UTC-05:00) Eastern Time (US & Canada)
America/Nassau,(UTC-05:00) Eastern Time (US & Canada)
America/New_York,(UTC-05:00) Eastern Time (US & Canada)
America/Nipigon,(UTC-05:00) Eastern Time (US & Canada)
America/Panama,Quito"
America/Pangnirtung,(UTC-05:00) Eastern Time (US & Canada)
America/Port-au-Prince,(UTC-05:00) Eastern Time (US & Canada)
America/Resolute,(UTC-05:00) Eastern Time (US & Canada)
America/Thunder_Bay,(UTC-05:00) Eastern Time (US & Canada)
America/Toronto,(UTC-05:00) Eastern Time (US & Canada)
America/Caracas,-4.5,Venezuela Standard Time,(UTC-04:30) Caracas
America/Anguilla,-4,Pacific SA Standard Time,(UTC-04:00) Santiago
America/Antigua,Atlantic Standard Time,(UTC-04:00) Atlantic Time (Canada)
America/Aruba,(UTC-04:00) Atlantic Time (Canada)
America/Asuncion,Paraguay Standard Time,(UTC-04:00) Asuncion
America/Barbados,(UTC-04:00) Santiago
America/Blanc-Sablon,(UTC-04:00) Atlantic Time (Canada)
America/Boa_Vista,(UTC-04:00) Atlantic Time (Canada)
America/Campo_Grande,(UTC-04:00) Atlantic Time (Canada)
America/Cuiaba,Central Brazilian Standard Time,(UTC-04:00) Cuiaba
America/Curacao,(UTC-04:00) Cuiaba
America/Dominica,(UTC-04:00) Santiago
America/Eirunepe,(UTC-04:00) Atlantic Time (Canada)
America/Glace_Bay,(UTC-04:00) Atlantic Time (Canada)
America/Goose_Bay,(UTC-04:00) Atlantic Time (Canada)
America/Grenada,(UTC-04:00) Atlantic Time (Canada)
America/Guadeloupe,(UTC-04:00) Atlantic Time (Canada)
America/Guyana,(UTC-04:00) Atlantic Time (Canada)
America/Halifax,(UTC-04:00) Atlantic Time (Canada)
America/La_Paz,SA Western Standard Time,"(UTC-04:00) Georgetown,Manaus,San Juan"
America/Manaus,San Juan"
America/Marigot,(UTC-04:00) Atlantic Time (Canada)
America/Martinique,(UTC-04:00) Atlantic Time (Canada)
America/Moncton,(UTC-04:00) Atlantic Time (Canada)
America/Montserrat,(UTC-04:00) Atlantic Time (Canada)
America/Port_of_Spain,(UTC-04:00) Atlantic Time (Canada)
America/Porto_Velho,(UTC-04:00) Cuiaba
America/Puerto_Rico,(UTC-04:00) Cuiaba
America/Rio_Branco,(UTC-04:00) Cuiaba
America/Santiago,(UTC-04:00) Santiago
America/Santo_Domingo,(UTC-04:00) Atlantic Time (Canada)
America/St_Barthelemy,(UTC-04:00) Atlantic Time (Canada)
America/St_Kitts,(UTC-04:00) Atlantic Time (Canada)
America/St_Lucia,(UTC-04:00) Atlantic Time (Canada)
America/St_Thomas,(UTC-04:00) Atlantic Time (Canada)
America/St_Vincent,(UTC-04:00) Atlantic Time (Canada)
America/Thule,(UTC-04:00) Atlantic Time (Canada)
America/Tortola,(UTC-04:00) Atlantic Time (Canada)
Antarctica/Palmer,(UTC-04:00) Atlantic Time (Canada)
Atlantic/Bermuda,(UTC-04:00) Atlantic Time (Canada)
America/St_Johns,-3.5,Newfoundland Standard Time,(UTC-03:30) Newfoundland
America/Araguaina,-3,E. South America Standard Time,(UTC-03:00) Brasilia
America/Argentina/Buenos_Aires,Argentina Standard Time,(UTC-03:00) Buenos Aires
America/Argentina/Catamarca,(UTC-03:00) Buenos Aires
America/Argentina/Cordoba,(UTC-03:00) Buenos Aires
America/Argentina/Jujuy,(UTC-03:00) Buenos Aires
America/Argentina/La_Rioja,(UTC-03:00) Buenos Aires
America/Argentina/Mendoza,(UTC-03:00) Buenos Aires
America/Argentina/Rio_Gallegos,(UTC-03:00) Buenos Aires
America/Argentina/Salta,(UTC-03:00) Buenos Aires
America/Argentina/San_Juan,(UTC-03:00) Buenos Aires
America/Argentina/San_Luis,(UTC-03:00) Buenos Aires
America/Argentina/Tucuman,(UTC-03:00) Buenos Aires
America/Argentina/Ushuaia,(UTC-03:00) Buenos Aires
America/Bahia,(UTC-03:00) Brasilia
America/Belem,(UTC-03:00) Brasilia
America/Cayenne,SA Eastern Standard Time,"(UTC-03:00) Cayenne,Fortaleza"
America/Fortaleza,Fortaleza"
America/Godthab,Greenland Standard Time,(UTC-03:00) Greenland 
America/Maceio,(UTC-03:00) Brasilia
America/Miquelon,(UTC-03:00) Brasilia
America/Montevideo,Montevideo Standard Time,(UTC-03:00) Montevideo
America/Paramaribo,Fortaleza"
America/Recife,Fortaleza"
America/Santarem,(UTC-03:00) Brasilia
America/Sao_Paulo,(UTC-03:00) Brasilia
Antarctica/Rothera,(UTC-03:00) Buenos Aires
Atlantic/Stanley,(UTC-03:00) Buenos Aires
America/Noronha,-2,Mid-Atlantic Standard Time,(UTC-02:00) Mid-Atlantic
Atlantic/South_Georgia,(UTC-02:00) Mid-Atlantic
America/scoresbysund,-1,Azores Standard Time,(UTC-01:00) Azores
Atlantic/Azores,(UTC-01:00) Azores
Atlantic/Cape_Verde,Cape Verde Standard Time,(UTC-01:00) Cape Verde Is.
Africa/Abidjan,GMT Standard Time,"(UTC) Dublin,Edinburgh,Lisbon,London"
Africa/Accra,London"
Africa/Bamako,London"
Africa/Banjul,London"
Africa/Bissau,London"
Africa/Casablanca,Morocco Standard Time,(UTC) Casablanca
Africa/Conakry,London"
Africa/Dakar,London"
Africa/El_Aaiun,London"
Africa/Freetown,London"
Africa/Lome,London"
Africa/Monrovia,London"
Africa/Nouakchott,London"
Africa/Ouagadougou,London"
Africa/Sao_Tome,London"
America/Danmarkshavn,London"
Antarctica/Vostok,London"
Atlantic/Canary,London"
Atlantic/Faroe,London"
Atlantic/Madeira,London"
Atlantic/Reykjavik,Greenwich Standard Time,"(UTC) Monrovia,Reykjavik"
Atlantic/St_Helena,Reykjavik"
Europe/Dublin,London"
Europe/Guernsey,London"
Europe/Isle_of_Man,London"
Europe/Jersey,London"
Europe/Lisbon,London"
Europe/London,London"
GMT,London"
UTC,UTC,(UTC) Coordinated Universal Time
Africa/Algiers,1,W. Central Africa Standard Time,(UTC+01:00) West Central Africa
Africa/Bangui,(UTC+01:00) West Central Africa
Africa/Brazzaville,(UTC+01:00) West Central Africa
Africa/Ceuta,(UTC+01:00) West Central Africa
Africa/Douala,(UTC+01:00) West Central Africa
Africa/Kinshasa,(UTC+01:00) West Central Africa
Africa/Lagos,(UTC+01:00) West Central Africa
Africa/Libreville,(UTC+01:00) West Central Africa
Africa/Luanda,(UTC+01:00) West Central Africa
Africa/Malabo,(UTC+01:00) West Central Africa
Africa/Ndjamena,(UTC+01:00) West Central Africa
Africa/Niamey,(UTC+01:00) West Central Africa
Africa/Porto-Novo,(UTC+01:00) West Central Africa
Africa/Tunis,(UTC+01:00) West Central Africa
Africa/Windhoek,Namibia Standard Time,(UTC+01:00) Windhoek
Arctic/Longyearbyen,W. Europe Standard Time,"(UTC+01:00) Amsterdam,Berlin,Bern,Rome,Stockholm,Vienna"
Europe/Amsterdam,Vienna"
Europe/Andorra,Vienna"
Europe/Belgrade,Central Europe Standard Time,"(UTC+01:00) Belgrade,Bratislava,Budapest,Ljubljana,Prague"
Europe/Berlin,Vienna"
Europe/Bratislava,Prague"
Europe/Brussels,Romance Standard Time,"(UTC+01:00) Brussels,Copenhagen,Madrid,Paris"
Europe/Budapest,Prague"
Europe/Copenhagen,Paris"
Europe/Gibraltar,Vienna"
Europe/Ljubljana,Prague"
Europe/Luxembourg,Vienna"
Europe/Madrid,Paris"
Europe/Malta,Vienna"
Europe/Monaco,Vienna"
Europe/Oslo,Vienna"
Europe/Paris,Paris"
Europe/Podgorica,Vienna"
Europe/Prague,Prague"
Europe/Rome,Vienna"
Europe/San_Marino,Vienna"
Europe/Sarajevo,"(UTC+01:00) Sarajevo,Skopje,Warsaw,Zagreb"
Europe/Skopje,Zagreb"
Europe/Stockholm,Vienna"
Europe/Tirane,Vienna"
Europe/Vaduz,Vienna"
Europe/Vatican,Vienna"
Europe/Vienna,Vienna"
Europe/Warsaw,Zagreb"
Europe/Zagreb,Zagreb"
Europe/Zurich,Vienna"
Africa/Blantyre,2,South Africa Standard Time,"(UTC+02:00) Harare,Pretoria"
Africa/Bujumbura,Pretoria"
Africa/Cairo,Egypt Standard Time,(UTC+02:00) Cairo
Africa/Gaborone,Pretoria"
Africa/Harare,Pretoria"
Africa/Johannesburg,Pretoria"
Africa/Kigali,Pretoria"
Africa/Lubumbashi,Pretoria"
Africa/Lusaka,Pretoria"
Africa/Maputo,Pretoria"
Africa/Maseru,Pretoria"
Africa/Mbabane,Pretoria"
Africa/Tripoli,Middle East Standard Time,(UTC+02:00) Beirut
Asia/Amman,Jordan Standard Time,(UTC+02:00) Amman
Asia/Beirut,(UTC+02:00) Beirut
Asia/Damascus,Syria Standard Time,(UTC+02:00) Damascus
Asia/Gaza,(UTC+02:00) Beirut
Asia/Jerusalem,Israel Standard Time,(UTC+02:00) Jerusalem 
Asia/Nicosia,GTB Standard Time,"(UTC+02:00) Athens,Bucharest"
Europe/Athens,Bucharest"
Europe/Bucharest,Bucharest"
Europe/Chisinau,E. Europe Standard Time,(UTC+02:00) Minsk
Europe/Helsinki,FLE Standard Time,"(UTC+02:00) Helsinki,Kyiv,Riga,Sofia,Tallinn,Vilnius"
Europe/Istanbul,Turkey Standard Time,(UTC+02:00) Istanbul 
Europe/Kiev,(UTC+02:00) Minsk
Europe/Mariehamn,(UTC+02:00) Minsk
Europe/Riga,Vilnius"
Europe/Simferopol,(UTC+02:00) Minsk
Europe/Sofia,Vilnius"
Europe/Tallinn,Vilnius"
Europe/Uzhgorod,(UTC+02:00) Minsk
Europe/Vilnius,Vilnius"
Europe/Zaporozhye,(UTC+02:00) Minsk
Africa/Addis_Ababa,3,E. Africa Standard Time,(UTC+03:00) Nairobi
Africa/Asmara,(UTC+03:00) Nairobi
Africa/Dar_es_Salaam,(UTC+03:00) Nairobi
Africa/Djibouti,(UTC+03:00) Nairobi
Africa/Juba,(UTC+03:00) Nairobi
Africa/Kampala,(UTC+03:00) Nairobi
Africa/Khartoum,(UTC+03:00) Nairobi
Africa/Mogadishu,(UTC+03:00) Nairobi
Africa/Nairobi,(UTC+03:00) Nairobi
Antarctica/Syowa,Kaliningrad Standard Time,(UTC+03:00) Kaliningrad
Asia/Aden,(UTC+03:00) Kaliningrad
Asia/Baghdad,Arabic Standard Time,(UTC+03:00) Baghdad
Asia/Bahrain,(UTC+03:00) Baghdad
Asia/Kuwait,Arab Standard Time,"(UTC+03:00) Kuwait,Riyadh"
Asia/Qatar,Riyadh"
Asia/Riyadh,Riyadh"
Europe/Kaliningrad,(UTC+03:00) Kaliningrad
Europe/Minsk,(UTC+03:00) Kaliningrad
Indian/Antananarivo,Riyadh"
Indian/Comoro,Riyadh"
Indian/Mayotte,Riyadh"
Asia/Tehran,3.5,Iran Standard Time,(UTC+03:30) Tehran 
Asia/Baku,4,Caucasus Standard Time,(UTC+04:00) Yerevan
Asia/Dubai,Arabian Standard Time,"(UTC+04:00) Abu Dhabi,Muscat"
Asia/Muscat,Muscat"
Asia/Tbilisi,Georgian Standard Time,(UTC+04:00) Tbilisi 
Asia/Yerevan,(UTC+04:00) Yerevan
Europe/Moscow,Russian Standard Time,"(UTC+04:00) Moscow,St. Petersburg,Volgograd"
Europe/Samara,Volgograd"
Europe/Volgograd,Volgograd"
Indian/Mahe,Mauritius Standard Time,(UTC+04:00) Port Louis 
Indian/Mauritius,(UTC+04:00) Port Louis 
Indian/Reunion,(UTC+04:00) Port Louis 
Asia/Kabul,4.5,Afghanistan Standard Time,(UTC+04:30) Kabul
Asia/Aqtau,5,West Asia Standard Time,(UTC+05:00) Tashkent 
Asia/Aqtobe,(UTC+05:00) Tashkent 
Asia/Ashgabat,(UTC+05:00) Tashkent 
Asia/Dushanbe,(UTC+05:00) Tashkent 
Asia/Karachi,Pakistan Standard Time,"(UTC+05:00) Islamabad,Karachi"
Asia/Oral,(UTC+05:00) Tashkent 
Asia/Samarkand,(UTC+05:00) Tashkent 
Asia/Tashkent,(UTC+05:00) Tashkent 
Indian/Kerguelen,(UTC+05:00) Tashkent 
Indian/Maldives,(UTC+05:00) Tashkent 
Asia/Colombo,5.5,Sri Lanka Standard Time,(UTC+05:30) Sri Jayawardenepura
Asia/Kolkata,India Standard Time,"(UTC+05:30) Chennai,Kolkata,Mumbai,New Delhi"
Asia/Kathmandu,5.75,Nepal Standard Time,(UTC+05:45) Kathmandu
Antarctica/Mawson,6,Central Asia Standard Time,(UTC+06:00) Astana
Asia/Almaty,(UTC+06:00) Astana
Asia/Bishkek,(UTC+06:00) Astana
Asia/Dhaka,Bangladesh Standard Time,(UTC+06:00) Dhaka
Asia/Qyzylorda,(UTC+06:00) Astana
Asia/Thimphu,(UTC+06:00) Astana
Asia/Yekaterinburg,Ekaterinburg Standard Time,(UTC+06:00) Ekaterinburg
Indian/Chagos,(UTC+06:00) Astana
Asia/Rangoon,6.5,Myanmar Standard Time,(UTC+06:30) Yangon (Rangoon)
Indian/Cocos,(UTC+06:30) Yangon (Rangoon)
Antarctica/Davis,7,SE Asia Standard Time,"(UTC+07:00) Bangkok,Hanoi,Jakarta"
Asia/Bangkok,Jakarta"
Asia/Ho_Chi_Minh,Jakarta"
Asia/Hovd,N. Central Asia Standard Time,(UTC+07:00) Novosibirsk
Asia/Jakarta,Jakarta"
Asia/Novokuznetsk,(UTC+07:00) Novosibirsk
Asia/Novosibirsk,(UTC+07:00) Novosibirsk
Asia/Omsk,(UTC+07:00) Novosibirsk
Asia/Phnom_Penh,Jakarta"
Asia/Pontianak,Jakarta"
Asia/Vientiane,Jakarta"
Indian/Christmas,Jakarta"
Antarctica/Casey,8,W. Australia Standard Time,(UTC+08:00) Perth
Asia/Brunei,North Asia Standard Time,(UTC+08:00) Krasnoyarsk
Asia/Choibalsan,China Standard Time,"(UTC+08:00) Beijing,Chongqing,Hong Kong,Urumqi"
Asia/Chongqing,Urumqi"
Asia/Harbin,Urumqi"
Asia/Hong_Kong,Urumqi"
.... Cut ....

由于邮政大小的限制,必须裁减 – 在链接的地址获取完整的CSV.

相关文章

(1)when you ping a computer from itsafe,the ping command should return the local IP address. (...
1、点击win菜单,点击设置图标 2、选择系统选项 3、选择应用与程序选项 4、拉到最下方,选择程序与功能...
目前一直直接往Windows 2008 R2 Server中复制文件(暂时还没有搭建ftp服务),突然不能复制了,于是百度...
windows下使用vscode配合xebug调试php脚本 要下载有php_xebug.dll扩展的版本,最新版可能没有这个扩展,p...
在控制面板的程序与功能里启用和关闭windows功能打开,适用于linux的windows子系统
效果演示 推荐一个非常牛的文档网站生成器:docsify 我通过这个工具,成功将码云上的个人学习笔记发布到...