如果系统不考虑全球化的话，那么我们不用考虑时区的问题，因为我们可以认为中国境内的计算机全部用的是北京时间。

安装以下两个 Nuget 包

TimeZoneInfo

TimeZoneInfo 是一个关于时区的静态类，可以使得我们方便的操作与时区相关的信息
对于一个开放于全球的网站或服务，在时间上的显示是一个问题，因为各个国家都会有所谓的时差，好在 .Net 提供了 TimeZoneInfo 类来解决这个问题。
TimeZoneInfo 类的方法可用于将一个时区的时间转换为其他任意时区的相应时间

静态成员：

获取 TimeZoneInfo

//.net 自带
Console.WriteLine(TimeZoneInfo.Local);//服务器时间
Console.WriteLine(TimeZoneInfo.Utc);//UTC时间
//TimeZoneConverter
Console.WriteLine(TZConvert.GetTimeZoneInfo("Central Standard Time"));//中部时间(美国和加拿大)
Console.WriteLine(TZConvert.GetTimeZoneInfo("America/New_York"));//美国时间
Console.WriteLine(TZConvert.GetTimeZoneInfo("Asia/Shanghai"));//上海时间
TimeZoneInfo timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("China Standard Time");
DateTime dateTime = TimeZoneInfo.ConvertTime(DateTime.Now, timeZoneInfo);
DateTime dt = TimeZoneInfo.ConvertTimeToUtc(DateTime.Now, TimeZoneInfo.Local);
DateTime dt1 = TimeZoneInfo.ConvertTimeFromUtc(dt, timeZoneInfo);
//NodaTime方式
Instant now = SystemClock.Instance.GetCurrentInstant();
var shanghaiZone = DateTimeZoneProviders.Tzdb["Asia/Shanghai"];
var shanghaiZone2 = NodaTime.DateTimeZoneProviders.Tzdb.GetZoneOrNull("America/New_York");
DateTime dateTime3= now.InZone(shanghaiZone).ToDateTimeUnspecified();
获取全部 TimeZoneInfo
官网文档地址
//获取所有Standard Time
foreach (TimeZoneInfo z in TimeZoneInfo.GetSystemTimeZones())
    Console.WriteLine(z.Id + "," + z.BaseUtcOffset + "," + z.StandardName + "," + z.DisplayName + "," + z.DaylightName);
    System.Diagnostics.Debug.WriteLine(z.Id + "," + z.BaseUtcOffset + "," + z.StandardName + "," + z.DisplayName + "," + z.DaylightName);
//NodaTime
var list = NodaTime.DateTimeZoneProviders.Bcl.Ids;
    tZCode : "Morocco Standard Time",
    tZDesc : "(GMT) Casablanca"
    tZCode : "GMT Standard Time",
    tZDesc : "(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London"
    tZCode : "Greenwich Standard Time",
    tZDesc : "(GMT) Monrovia, Reykjavik"
    tZCode : "W. Europe Standard Time",
    tZDesc : "(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna"
    tZCode : "Central Europe Standard Time",
    tZDesc : "(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague"
    tZCode : "Romance Standard Time",
    tZDesc : "(GMT+01:00) Brussels, Copenhagen, Madrid, Paris"
    tZCode : "Central European Standard Time",
    tZDesc : "(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb"
    tZCode : "W. Central Africa Standard Time",
    tZDesc : "(GMT+01:00) West Central Africa"
    tZCode : "Jordan Standard Time",
    tZDesc : "(GMT+02:00) Amman"
    tZCode : "GTB Standard Time",
    tZDesc : "(GMT+02:00) Athens, Bucharest, Istanbul"
    tZCode : "Middle East Standard Time",
    tZDesc : "(GMT+02:00) Beirut"
    tZCode : "Egypt Standard Time",
    tZDesc : "(GMT+02:00) Cairo"
    tZCode : "South Africa Standard Time",
    tZDesc : "(GMT+02:00) Harare, Pretoria"
    tZCode : "FLE Standard Time",
    tZDesc : "(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius"
    tZCode : "Israel Standard Time",
    tZDesc : "(GMT+02:00) Jerusalem"
    tZCode : "E. Europe Standard Time",
    tZDesc : "(GMT+02:00) Minsk"
    tZCode : "Namibia Standard Time",
    tZDesc : "(GMT+02:00) Windhoek"
    tZCode : "Arabic Standard Time",
    tZDesc : "(GMT+03:00) Baghdad"
    tZCode : "Arab Standard Time",
    tZDesc : "(GMT+03:00) Kuwait, Riyadh"
    tZCode : "Russian Standard Time",
    tZDesc : "(GMT+03:00) Moscow, St. Petersburg, Volgograd"
    tZCode : "E. Africa Standard Time",
    tZDesc : "(GMT+03:00) Nairobi"
    tZCode : "Georgian Standard Time",
    tZDesc : "(GMT+03:00) Tbilisi"
    tZCode : "Iran Standard Time",
    tZDesc : "(GMT+03:30) Tehran"
    tZCode : "Arabian Standard Time",
    tZDesc : "(GMT+04:00) Abu Dhabi, Muscat"
    tZCode : "Azerbaijan Standard Time",
    tZDesc : "(GMT+04:00) Baku"
    tZCode : "Mauritius Standard Time",
    tZDesc : "(GMT+04:00) Port Louis"
    tZCode : "Caucasus Standard Time",
    tZDesc : "(GMT+04:00) Yerevan"
    tZCode : "Afghanistan Standard Time",
    tZDesc : "(GMT+04:30) Kabul"
    tZCode : "Ekaterinburg Standard Time",
    tZDesc : "(GMT+05:00) Ekaterinburg"
    tZCode : "Pakistan Standard Time",
    tZDesc : "(GMT+05:00) Islamabad, Karachi"
    tZCode : "West Asia Standard Time",
    tZDesc : "(GMT+05:00) Tashkent"
    tZCode : "India Standard Time",
    tZDesc : "(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi"
    tZCode : "Sri Lanka Standard Time",
    tZDesc : "(GMT+05:30) Sri Jayawardenepura"
    tZCode : "Nepal Standard Time",
    tZDesc : "(GMT+05:45) Kathmandu"
    tZCode : "N. Central Asia Standard Time",
    tZDesc : "(GMT+06:00) Almaty, Novosibirsk"
    tZCode : "Central Asia Standard Time",
    tZDesc : "(GMT+06:00) Astana, Dhaka"
    tZCode : "Myanmar Standard Time",
    tZDesc : "(GMT+06:30) Yangon (Rangoon)"
    tZCode : "SE Asia Standard Time",
    tZDesc : "(GMT+07:00) Bangkok, Hanoi, Jakarta"
    tZCode : "North Asia Standard Time",
    tZDesc : "(GMT+07:00) Krasnoyarsk"
    tZCode : "China Standard Time",
    tZDesc : "(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi"
    tZCode : "North Asia East Standard Time",
    tZDesc : "(GMT+08:00) Irkutsk, Ulaan Bataar"
    tZCode : "Singapore Standard Time",
    tZDesc : "(GMT+08:00) Kuala Lumpur, Singapore"
    tZCode : "W. Australia Standard Time",
    tZDesc : "(GMT+08:00) Perth"
    tZCode : "Taipei Standard Time",
    tZDesc : "(GMT+08:00) Taipei"
    tZCode : "Tokyo Standard Time",
    tZDesc : "(GMT+09:00) Osaka, Sapporo, Tokyo"
    tZCode : "Korea Standard Time",
    tZDesc : "(GMT+09:00) Seoul"
    tZCode : "Yakutsk Standard Time",
    tZDesc : "(GMT+09:00) Yakutsk"
    tZCode : "Cen. Australia Standard Time",
    tZDesc : "(GMT+09:30) Adelaide"
    tZCode : "AUS Central Standard Time",
    tZDesc : "(GMT+09:30) Darwin"
    tZCode : "E. Australia Standard Time",
    tZDesc : "(GMT+10:00) Brisbane"
    tZCode : "AUS Eastern Standard Time",
    tZDesc : "(GMT+10:00) Canberra, Melbourne, Sydney"
    tZCode : "West Pacific Standard Time",
    tZDesc : "(GMT+10:00) Guam, Port Moresby"
    tZCode : "Tasmania Standard Time",
    tZDesc : "(GMT+10:00) Hobart"
    tZCode : "Vladivostok Standard Time",
    tZDesc : "(GMT+10:00) Vladivostok"
    tZCode : "Central Pacific Standard Time",
    tZDesc : "(GMT+11:00) Magadan, Solomon Is., New Caledonia"
    tZCode : "New Zealand Standard Time",
    tZDesc : "(GMT+12:00) Auckland, Wellington"
    tZCode : "Fiji Standard Time",
    tZDesc : "(GMT+12:00) Fiji, Kamchatka, Marshall Is."
    tZCode : "Tonga Standard Time",
    tZDesc : "(GMT+13:00) Nuku'alofa"
    tZCode : "Azores Standard Time",
    tZDesc : "(GMT-01:00) Azores"
    tZCode : "Cape Verde Standard Time",
    tZDesc : "(GMT-01:00) Cape Verde Is."
    tZCode : "Mid-Atlantic Standard Time",
    tZDesc : "(GMT-02:00) Mid-Atlantic"
    tZCode : "E. South America Standard Time",
    tZDesc : "(GMT-03:00) Brasilia"
    tZCode : "Argentina Standard Time",
    tZDesc : "(GMT-03:00) Buenos Aires"
    tZCode : "SA Eastern Standard Time",
    tZDesc : "(GMT-03:00) Georgetown"
    tZCode : "Greenland Standard Time",
    tZDesc : "(GMT-03:00) Greenland"
    tZCode : "Montevideo Standard Time",
    tZDesc : "(GMT-03:00) Montevideo"
    tZCode : "Newfoundland Standard Time",
    tZDesc : "(GMT-03:30) Newfoundland"
    tZCode : "Atlantic Standard Time",
    tZDesc : "(GMT-04:00) Atlantic Time (Canada)"
    tZCode : "SA Western Standard Time",
    tZDesc : "(GMT-04:00) La Paz"
    tZCode : "Central Brazilian Standard Time",
    tZDesc : "(GMT-04:00) Manaus"
    tZCode : "Pacific SA Standard Time",
    tZDesc : "(GMT-04:00) Santiago"
    tZCode : "Venezuela Standard Time",
    tZDesc : "(GMT-04:30) Caracas"
    tZCode : "SA Pacific Standard Time",
    tZDesc : "(GMT-05:00) Bogota, Lima, Quito, Rio Branco"
    tZCode : "Eastern Standard Time",
    tZDesc : "(GMT-05:00) Eastern Time (US & Canada)"
    tZCode : "US Eastern Standard Time",
    tZDesc : "(GMT-05:00) Indiana (East)"
    tZCode : "Central America Standard Time",
    tZDesc : "(GMT-06:00) Central America"
    tZCode : "Central Standard Time",
    tZDesc : "(GMT-06:00) Central Time (US & Canada)"
    tZCode : "Central Standard Time (Mexico)",
    tZDesc : "(GMT-06:00) Guadalajara, Mexico City, Monterrey"
    tZCode : "Canada Central Standard Time",
    tZDesc : "(GMT-06:00) Saskatchewan"
    tZCode : "US Mountain Standard Time",
    tZDesc : "(GMT-07:00) Arizona"
    tZCode : "Mountain Standard Time (Mexico)",
    tZDesc : "(GMT-07:00) Chihuahua, La Paz, Mazatlan"
    tZCode : "Mountain Standard Time",
    tZDesc : "(GMT-07:00) Mountain Time (US & Canada)"
    tZCode : "Pacific Standard Time",
    tZDesc : "(GMT-08:00) Pacific Time (US & Canada)"
    tZCode : "Pacific Standard Time (Mexico)",
    tZDesc : "(GMT-08:00) Tijuana, Baja California"
    tZCode : "Alaskan Standard Time",
    tZDesc : "(GMT-09:00) Alaska"
    tZCode : "Hawaiian Standard Time",
    tZDesc : "(GMT-10:00) Hawaii"
    tZCode : "Samoa Standard Time",
    tZDesc : "(GMT-11:00) Midway Island, Samoa"
    tZCode : "Dateline Standard Time",
    tZDesc : "(GMT-12:00) International Date Line West"
Windwos 时区国家关系
官网文档地址
  
对应关系列表
Dateline Standard Time,(GMT-12:00)日界线西,国际日期变更线标准时间
Samoa Standard Time,(GMT-11:00) 中途岛，萨摩亚群岛,萨摩亚群岛标准时间
Hawaiian Standard Time,(GMT-10:00) 夏威夷,夏威夷标准时间
Alaskan Standard Time,(GMT-09:00) 阿拉斯加,阿拉斯加标准时间
Pacific Standard Time,(GMT-08:00) 太平洋时间(美国和加拿大)；蒂华纳,太平洋标准时间
US Mountain Standard Time,(GMT-07:00) 亚利桑那,美国山地标准时间
Mountain Standard Time,(GMT-07:00) 山地时间(美国和加拿大),山地标准时间
Mexico Standard Time 2,(GMT-07:00)奇瓦瓦，拉巴斯，马扎特兰,墨西哥标准时间 2
Central America Standard Time,(GMT-06:00) 中美洲,中美洲标准时间
Central Standard Time,(GMT-06:00) 中部时间(美国和加拿大),中部标准时间
Canada Central Standard Time,(GMT-06:00) 萨斯喀彻温,加拿大中部标准时间
Mexico Standard Time,(GMT-06:00)瓜达拉哈拉，墨西哥城，蒙特雷,墨西哥标准时间
Eastern Standard Time,(GMT-05:00) 东部时间(美国和加拿大),东部标准时间
US Eastern Standard Time,(GMT-05:00) 印地安那州(东部),美国东部标准时间
SA Pacific Standard Time,(GMT-05:00) 波哥大，利马，基多,南美州太平洋标准时间
SA Western Standard Time,(GMT-04:00) 加拉加斯，拉巴斯,南美州西部标准时间
Pacific SA Standard Time,(GMT-04:00) 圣地亚哥,南美州太平洋标准时间
Atlantic Standard Time,(GMT-04:00) 大西洋时间(加拿大),大西洋标准时间
Newfoundland Standard Time,(GMT-03:30) 纽芬兰,纽芬兰标准时间
E. South America Standard Time,(GMT-03:00) 巴西利亚,南美州东部标准时间
SA Eastern Standard Time,(GMT-03:00) 布宜诺斯艾利斯，乔治敦,南美州东部标准时间
Greenland Standard Time,(GMT-03:00) 格陵兰,格陵兰东部标准时间
Mid-Atlantic Standard Time,(GMT-02:00) 中大西洋,中大西洋标准时间
Azores Standard Time,(GMT-01:00) 亚速尔群岛,亚速尔群岛标准时间
Cape Verde Standard Time,(GMT-01:00) 佛得角群岛,佛得角群岛标准时间
Greenwich Standard Time,(GMT) 卡萨布兰卡，蒙罗维亚,格林威治标准时间
GMT Standard Time,(GMT) 格林威治标准时间: 都柏林, 爱丁堡, 伦敦, 里斯本,格林威治标准时间
W. Central Africa Standard Time,(GMT+01:00) 中非西部,中非西部标准时间
Romance Standard Time,(GMT+01:00) 布鲁塞尔，哥本哈根，马德里，巴黎,罗马标准时间
Central European Standard Time,(GMT+01:00) 萨拉热窝，斯科普里，华沙，萨格勒布,中欧标准时间
Central Europe Standard Time,(GMT+01:00) 贝尔格莱德，布拉迪斯拉发，布达佩斯，卢布尔雅那，布拉格,中欧标准时间
W. Europe Standard Time,(GMT+01:00) 阿姆斯特丹，柏林，伯尔尼，罗马，斯德哥尔摩，维也纳,西欧标准时间
South Africa Standard Time,(GMT+02:00) 哈拉雷，比勒陀利亚,南非标准时间
E. Europe Standard Time,(GMT+02:00) 布加勒斯特,东欧标准时间
Egypt Standard Time,(GMT+02:00) 开罗,埃及标准时间
Israel Standard Time,(GMT+02:00) 耶路撒冷,耶路撒冷标准时间
FLE Standard Time,(GMT+02:00) 赫尔辛基，基辅，里加，索非亚，塔林，维尔纽斯,FLE 标准时间
GTB Standard Time,(GMT+02:00) 雅典，贝鲁特，伊斯坦布尔，明斯克,GTB 标准时间
E. Africa Standard Time,(GMT+03:00) 内罗毕,东非标准时间
Arabic Standard Time,(GMT+03:00) 巴格达,阿拉伯标准时间
Arab Standard Time,(GMT+03:00) 科威特，利雅得,阿拉伯标准时间
Russian Standard Time,(GMT+03:00) 莫斯科，圣彼得堡, 伏尔加格勒,俄罗斯标准时间
Iran Standard Time,(GMT+03:30) 德黑兰,伊朗标准时间
Caucasus Standard Time,(GMT+04:00) 巴库，第比利斯，埃里温,高加索标准时间
Arabian Standard Time,(GMT+04:00) 阿布扎比，马斯喀特,阿拉伯半岛标准时间
Afghanistan Standard Time,(GMT+04:30) 喀布尔,阿富汗标准时间
West Asia Standard Time,(GMT+05:00) 伊斯兰堡，卡拉奇，塔什干,西亚标准时间
Ekaterinburg Standard Time,(GMT+05:00) 叶卡捷琳堡,叶卡捷琳堡标准时间
India Standard Time,(GMT+05:30) 马德拉斯，加尔各答，孟买，新德里,印度标准时间
Nepal Standard Time,(GMT+05:45) 加德满都,尼泊尔标准时间
Sri Lanka Standard Time,(GMT+06:00) 斯里哈亚华登尼普拉,斯里兰卡标准时间
N. Central Asia Standard Time,(GMT+06:00) 阿拉木图，新西伯利亚,中亚北部标准时间
Central Asia Standard Time,(GMT+06:00) 阿斯塔纳，达卡,中亚标准时间
Myanmar Standard Time,(GMT+06:30) 仰光,缅甸标准时间
North Asia Standard Time,(GMT+07:00) 克拉斯诺亚尔斯克,北亚标准时间
SE Asia Standard Time,(GMT+07:00) 曼谷，河内，雅加达,东南亚标准时间
North Asia East Standard Time,(GMT+08:00) 伊尔库茨克，乌兰巴图,北亚东部标准时间
China Standard Time,(GMT+08:00) 北京，重庆，香港特别行政区，乌鲁木齐,中国标准时间
Taipei Standard Time,(GMT+08:00) 台北,台北标准时间
Singapore Standard Time,(GMT+08:00) 吉隆坡，新加坡,马来西亚半岛标准时间
W. Australia Standard Time,(GMT+08:00) 珀斯,澳大利亚西部标准时间
Tokyo Standard Time,(GMT+09:00) 大坂，札幌，东京,东京标准时间
Korea Standard Time,(GMT+09:00) 汉城,韩国标准时间
Yakutsk Standard Time,(GMT+09:00) 雅库茨克,雅库茨克标准时间
AUS Central Standard Time,(GMT+09:30) 达尔文,澳大利亚中部标准时间
Cen. Australia Standard Time,(GMT+09:30) 阿德莱德,澳大利亚中部标准时间
West Pacific Standard Time,(GMT+10:00) 关岛，莫尔兹比港,西太平洋标准时间
AUS Eastern Standard Time,(GMT+10:00) 堪培拉，墨尔本，悉尼,澳大利亚东部标准时间
E. Australia Standard Time,(GMT+10:00) 布里斯班,澳大利亚东部标准时间
Vladivostok Standard Time,(GMT+10:00) 符拉迪沃斯托克,符拉迪沃斯托克标准时间
Tasmania Standard Time,(GMT+10:00) 霍巴特,塔斯马尼亚岛标准时间
Central Pacific Standard Time,(GMT+11:00) 马加丹，索罗门群岛，新喀里多尼亚,太平洋中部标准时间
New Zealand Standard Time,(GMT+12:00) 奥克兰，惠灵顿,新西兰标准时间
Fiji Standard Time,(GMT+12:00) 斐济，堪察加半岛，马绍尔群岛,斐济标准时间
Tonga Standard Time,(GMT+13:00) 努库阿洛法,汤加标准时间
获取服务器Olson时区
var x = NodaTime.DateTimeZoneProviders.Tzdb.GetSystemDefault();
Console.WriteLine(x);
获取全部Olson时区
using NodaTime.TimeZones;
using NodaTime.Extensions;
//第一种
foreach (var item in TzdbDateTimeZoneSource.Default.ZoneLocations.ToList())
    Console.WriteLine($"{item.ZoneId} ({item.CountryName})");
//第二种
var list2 = NodaTime.DateTimeZoneProviders.Tzdb.Ids;
//第三种
var list3 = NodaTime.DateTimeZoneProviders.Tzdb.GetAllZones().ToList();
var olsonWindowsTimes = new Dictionary<string, string>()
        { "Africa/Bangui", "W. Central Africa Standard Time" },
        { "Africa/Cairo", "Egypt Standard Time" },
        { "Africa/Casablanca", "Morocco Standard Time" },
        { "Africa/Harare", "South Africa Standard Time" },
        { "Africa/Johannesburg", "South Africa Standard Time" },
        { "Africa/Lagos", "W. Central Africa Standard Time" },
        { "Africa/Monrovia", "Greenwich Standard Time" },
        { "Africa/Nairobi", "E. Africa Standard Time" },
        { "Africa/Windhoek", "Namibia Standard Time" },
        { "America/Anchorage", "Alaskan Standard Time" },
        { "America/Argentina/San_Juan", "Argentina Standard Time" },
        { "America/Asuncion", "Paraguay Standard Time" },
        { "America/Bahia", "Bahia Standard Time" },
        { "America/Bogota", "SA Pacific Standard Time" },
        { "America/Buenos_Aires", "Argentina Standard Time" },
        { "America/Caracas", "Venezuela Standard Time" },
        { "America/Cayenne", "SA Eastern Standard Time" },
        { "America/Chicago", "Central Standard Time" },
        { "America/Chihuahua", "Mountain Standard Time (Mexico)" },
        { "America/Cuiaba", "Central Brazilian Standard Time" },
        { "America/Denver", "Mountain Standard Time" },
        { "America/Fortaleza", "SA Eastern Standard Time" },
        { "America/Godthab", "Greenland Standard Time" },
        { "America/Guatemala", "Central America Standard Time" },
        { "America/Halifax", "Atlantic Standard Time" },
        { "America/Indianapolis", "US Eastern Standard Time" },
        { "America/Indiana/Indianapolis", "US Eastern Standard Time" },
        { "America/La_Paz", "SA Western Standard Time" },
        { "America/Los_Angeles", "Pacific Standard Time" },
        { "America/Mexico_City", "Mexico Standard Time" },
        { "America/Montevideo", "Montevideo Standard Time" },
        { "America/New_York", "Eastern Standard Time" },
        { "America/Noronha", "UTC-02" },
        { "America/Phoenix", "US Mountain Standard Time" },
        { "America/Regina", "Canada Central Standard Time" },
        { "America/Santa_Isabel", "Pacific Standard Time (Mexico)" },
        { "America/Santiago", "Pacific SA Standard Time" },
        { "America/Sao_Paulo", "E. South America Standard Time" },
        { "America/St_Johns", "Newfoundland Standard Time" },
        { "America/Tijuana", "Pacific Standard Time" },
        { "Antarctica/McMurdo", "New Zealand Standard Time" },
        { "Atlantic/South_Georgia", "UTC-02" },
        { "Asia/Almaty", "Central Asia Standard Time" },
        { "Asia/Amman", "Jordan Standard Time" },
        { "Asia/Baghdad", "Arabic Standard Time" },
        { "Asia/Baku", "Azerbaijan Standard Time" },
        { "Asia/Bangkok", "SE Asia Standard Time" },
        { "Asia/Beirut", "Middle East Standard Time" },
        { "Asia/Calcutta", "India Standard Time" },
        { "Asia/Colombo", "Sri Lanka Standard Time" },
        { "Asia/Damascus", "Syria Standard Time" },
        { "Asia/Dhaka", "Bangladesh Standard Time" },
        { "Asia/Dubai", "Arabian Standard Time" },
        { "Asia/Irkutsk", "North Asia East Standard Time" },
        { "Asia/Jerusalem", "Israel Standard Time" },
        { "Asia/Kabul", "Afghanistan Standard Time" },
        { "Asia/Kamchatka", "Kamchatka Standard Time" },
        { "Asia/Karachi", "Pakistan Standard Time" },
        { "Asia/Katmandu", "Nepal Standard Time" },
        { "Asia/Kolkata", "India Standard Time" },
        { "Asia/Krasnoyarsk", "North Asia Standard Time" },
        { "Asia/Kuala_Lumpur", "Singapore Standard Time" },
        { "Asia/Kuwait", "Arab Standard Time" },
        { "Asia/Magadan", "Magadan Standard Time" },
        { "Asia/Muscat", "Arabian Standard Time" },
        { "Asia/Novosibirsk", "N. Central Asia Standard Time" },
        { "Asia/Oral", "West Asia Standard Time" },
        { "Asia/Rangoon", "Myanmar Standard Time" },
        { "Asia/Riyadh", "Arab Standard Time" },
        { "Asia/Seoul", "Korea Standard Time" },
        { "Asia/Shanghai", "China Standard Time" },
        { "Asia/Singapore", "Singapore Standard Time" },
        { "Asia/Taipei", "Taipei Standard Time" },
        { "Asia/Tashkent", "West Asia Standard Time" },
        { "Asia/Tbilisi", "Georgian Standard Time" },
        { "Asia/Tehran", "Iran Standard Time" },
        { "Asia/Tokyo", "Tokyo Standard Time" },
        { "Asia/Ulaanbaatar", "Ulaanbaatar Standard Time" },
        { "Asia/Vladivostok", "Vladivostok Standard Time" },
        { "Asia/Yakutsk", "Yakutsk Standard Time" },
        { "Asia/Yekaterinburg", "Ekaterinburg Standard Time" },
        { "Asia/Yerevan", "Armenian Standard Time" },
        { "Atlantic/Azores", "Azores Standard Time" },
        { "Atlantic/Cape_Verde", "Cape Verde Standard Time" },
        { "Atlantic/Reykjavik", "Greenwich Standard Time" },
        { "Australia/Adelaide", "Cen. Australia Standard Time" },
        { "Australia/Brisbane", "E. Australia Standard Time" },
        { "Australia/Darwin", "AUS Central Standard Time" },
        { "Australia/Hobart", "Tasmania Standard Time" },
        { "Australia/Perth", "W. Australia Standard Time" },
        { "Australia/Sydney", "AUS Eastern Standard Time" },
        { "Etc/GMT", "UTC" },
        { "Etc/GMT+11", "UTC-11" },
        { "Etc/GMT+12", "Dateline Standard Time" },
        { "Etc/GMT+2", "UTC-02" },
        { "Etc/GMT-12", "UTC+12" },
        { "Europe/Amsterdam", "W. Europe Standard Time" },
        { "Europe/Athens", "GTB Standard Time" },
        { "Europe/Belgrade", "Central Europe Standard Time" },
        { "Europe/Berlin", "W. Europe Standard Time" },
        { "Europe/Brussels", "Romance Standard Time" },
        { "Europe/Budapest", "Central Europe Standard Time" },
        { "Europe/Dublin", "GMT Standard Time" },
        { "Europe/Helsinki", "FLE Standard Time" },
        { "Europe/Istanbul", "GTB Standard Time" },
        { "Europe/Kiev", "FLE Standard Time" },
        { "Europe/London", "GMT Standard Time" },
        { "Europe/Minsk", "E. Europe Standard Time" },
        { "Europe/Moscow", "Russian Standard Time" },
        { "Europe/Paris", "Romance Standard Time" },
        { "Europe/Sarajevo", "Central European Standard Time" },
        { "Europe/Warsaw", "Central European Standard Time" },
        { "Indian/Mauritius", "Mauritius Standard Time" },
        { "Pacific/Apia", "Samoa Standard Time" },
        { "Pacific/Auckland", "New Zealand Standard Time" },
        { "Pacific/Fiji", "Fiji Standard Time" },
        { "Pacific/Guadalcanal", "Central Pacific Standard Time" },
        { "Pacific/Guam", "West Pacific Standard Time" },
        { "Pacific/Honolulu", "Hawaiian Standard Time" },
        { "Pacific/Pago_Pago", "UTC-11" },
        { "Pacific/Port_Moresby", "West Pacific Standard Time" },
        { "Pacific/Tongatapu", "Tonga Standard Time" }
sqlserver 存储时间
推荐 sqlserver 中使用：datetime2。
date：3字节，表示范围：0001-01-01 到 9999-12-31
datetime：8字节，表示范围： 1753-01-01 00:00:00 到 9999-12-31 23:59:59
datetime2：6-8个字节，表示范围：0001-01-01 00:00:00 到 9999-12-31 23:59:59.9999999
smalldatetime：4个字节，表示范围：1900-01-01 00:00:00 到 2079-06-06 23:59:59
time：5个字节，表示范围： 00:00:00.0000000 到 23:59:59.9999999
datetimeoffset：10个字节，表示范围：0001-01-01 00:00:00 到 23:59:59.9999999，可表示时区