背景问题: 今天在做Excel动态列解析的时候,发现Excel中的日期解析出来居然是这种格式,emmm,这是个啥?
Military 0300Z zero-three-zero-zero hours, zero three hundred hours AM or A.M. - latin ante meridiem, meaning before midday, PM or P.M. - latin post meridiem, meaning after midday. Letter 'Z' in military time indicates ZULU Time Zone which is equivalent to UTC. UTC...
EEST /UTC+0300 WET Western European Time 西ヨーロッパ時間 ヨーロッパ 2025/01/12(日) 02:06 WET /UTC+0000 WEST Western European Summer Time 西ヨーロッパ時間(夏時間) ヨーロッパ 2025/01/12(日) 03:06 WEST /UTC+0100 AEST Australian Eastern Standard Time ...
UTC+0300夏 - 哈拉雷,比勒陀利亚 UTC+0200 UTC+02:00 开罗,耶路撒冷 UTC+0200夏 UTC+03:00 巴格达,科威特,利雅得,内罗毕 UTC+0300 - 莫斯科,圣彼得堡,伏尔加格勒 UTC+0400 UTC+03:30 德黑兰 UTC+0330夏 UTC+04:00 阿布扎比,马斯喀特 UTC+0400 i- 埃里温,巴库 UTC+0500夏 UTC+04:00 第比利斯,路易港 UTC...
UTC-0300 UTC-02:00 协调世界时-02 UTC-0200 - 中大西洋 UTC-0200 夏 UTC-01:00 佛得角群岛 UTC-0100 UTC-01:00 亚速尔群岛 UTC 夏 UTC 都柏林,爱丁堡,里斯本,伦敦 UTC+0100 夏 - 卡萨布兰卡, 蒙罗维亚,雷克雅未克, 协调世界时 UTC UTC+01:00 ...
0300 11 PM 10 PM 9 PM 8 PM 7 PM 0400 Midnight 11 PM 10 PM 9 PM 8 PM 0500 1 AM Midnight 11 PM 10 PM 9 PM 0600 2 AM 1 AM Midnight 11 PM 10 PM 0700 3 AM 2 AM 1 AM Midnight 11 PM 0800 4 AM 3 AM 2 AM 1 AM Midnight 0900 5 AM 4 AM 3 AM 2 AM 1 AM ...
-0300 - sign character (-) followed by a four digit time providing hours (03) and minutes (00) of the offset. Indicates three hour and zero minutes time differences to the west of the zero meridian. Military/NATO: Used by the U.S. military, Chinese military and others Papa - Military...
DateTime dt = DateTime.ParseExact(s,"ddd MMM dd HH:mm:ss UTCzzzz yyyy", System.Globalization....
Node（或者ICU）有一个bug，UTC+03:00也应该被解释为POSIX字符串。虽然不常用，但它确实符合TZ规范中...
+0300 - sign character (+) followed by a four digit time providing hours (03) and minutes (00) of the offset. Indicates three hour and zero minutes time differences to the east of the zero meridian. Military/NATO:Used by the U.S. military, Chinese military and others ...