澶忎护鏃朵粈涔堟椂鍊欏紑濮嬪拰缁撴潫(澶忎护鏃朵粈涔堟椂鍊欏紑濮嬪疄琛岀殑)
澶忎护鏃舵槸鎸囧湪澶忓灏嗘爣鍑嗘椂闂村悜鍓嶈皟鏁翠竴灏忔椂锛屼互渚挎洿濂藉湴鍒╃敤鍏夌収鏃堕棿銆傛牴鎹瀹氾紝澶忎护鏃跺湪姣忓勾鐨勪笁鏈堜腑鏃紑濮嬶紝鏃堕挓鍚戝墠璋冩暣涓€灏忔椂锛屽皢鏍囧噯鏃堕棿浠庢櫄涓?鐐硅皟鏁村埌鏃╀笂3鐐广€傝€屽浠ゆ椂浜庢瘡骞寸殑鍗佷竴鏈堝垵缁撴潫锛屾椂閽熷€掑洖涓€灏忔椂锛屽皢澶忎护鏃惰浆鎹㈠洖鏍囧噯鏃堕棿銆傝繖涓椂闂磋皟鏁寸殑鐩殑鏄负浜嗚妭鐪佽兘婧愬拰鎻愰珮鐢熸椿鏁堢巼锛屽悓鏃朵篃涓轰汉浠彁渚涙洿澶氱殑浼戦棽鏃堕棿銆?/p>
馃摙娆㈣繋鐐硅禐 锛氿煈?鏀惰棌 猸愮暀瑷€ 馃摑 濡傛湁閿欒鏁鎸囨锛岃祼浜虹帿鐟帮紝鎵嬬暀浣欓锛?/p>
馃摙鏈枃浣滆€咃細鐢眞ebmote 鍘熷垱
馃摙浣滆€呮牸瑷€锛氭棤灏界殑鎶樿吘鍚庯紝缁堜簬鍙堝洖鍒颁簡璧风偣锛屽伐鎺э紝鎴戞潵浜?锛?/p>
1. 鍓嶈█
鏈夊叧鏃ユ湡绫诲瀷锛屼及璁℃槸姣忎釜瀛︿範缂栫▼璇█閮戒細鎺ヨЕ鍒扮殑绫诲瀷姒傚康銆傚綋鐒朵綔涓哄井杞富鎺ㄧ殑c#灏ゅ叾瀵规棩鏈熺殑澶勭悊鏈夋洿澶氱殑姒傚康锛岃繕璁板緱鎬庝箞鏍煎紡鍖栨棩鏈熺被鍨嬪悧锛?/p>
// => 2025/02/28 08:09:55:2350 鏄熸湡浜?p>
DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss:ffff dddd");
浠婂ぉ鏄釜鐙壒鐨勬棩瀛愶紝浠呬互姝よ浠ｇ爜浣滀负璁板綍锛佸綋鐒朵互涓嬪唴瀹瑰苟涓嶆秹鍙婂埌c#缂栫▼璇█锛屼綔涓鸿鑰咃紝浣犲ぇ鍙笉瑕佹湁浠讳綍璐熸媴锛?/p>
浠ヤ笅鍙槸涓€浜涙湁鍏虫棩鏈熺殑闂锛屽笇鏈涗綘閮界煡閬撶瓟妗堝摝锛?/strong>
2. 1 骞?= 12 涓湀锛?/strong>
鐩存帴璇寸粨璁猴細鏈変簺鏃ュ巻浣跨敤闂版湀锛堣濡備腑鍥界殑鍐滃巻锛夛紝鍥犳涓€骞村彲浠ユ湁 13 涓湀锛堜粖骞撮棸浜屾湀锛夈€?/p>
鍦?.NET BCL 涓紝鎺ュ彈浠嬩簬 1 鍜?13 涔嬮棿鐨勫€笺€傝繖鏄负浜嗛€傚簲鍏锋湁闂版湀鐨勬棩鍘嗙郴缁燂紝渚嬪锛孒ebrew鍘嗗皢Adar浣滀负鏅€氬勾浠界殑绗?6 涓湀锛屽湪Hebrew闂板勾鏃讹紝 灏嗘湁Adar 1 鍜?Adar 2锛堢 6 涓湀鍜岀 7 涓湀锛夈€?/p>
鏈夊叴瓒ｇ殑鏈嬪弸浠彲浠ユ煡涓?code>Ethopian鏃ュ巻 鍜?code>Wondrous鏃ュ巻銆?/p>
3. 1 骞?= 365 鎴?366 澶?/strong>
浣犳槸涓嶆槸璁や负鍦ㄥ叕鍘嗕腑锛岄棸骞存湁366澶╋紝闄ゆ涔嬪骞舵棤寮傛牱銆?/p>
鐒惰€岃繃鍘绘湁鍚勭鍚勬牱鐨勪緥瀛愶紝涓€浜涘浗瀹舵敼鍙樹簡浠栦滑鐨勬棩鍘嗐€備緥濡傦紝鑻卞浗鍦?752骞存敼鍙樹簡浠栦滑鐨勬棩鍘嗭紝鑰屽湪鏈璋冩暣涓紝9鏈堝皯浜嗗ソ鍑犲ぉ锛屾敞鎰忕湅涓嬪浘鐨?code>September鏈堛€?/p>
浣滀负涓浗浜猴紝浣犺偗瀹氱煡閬撳啘鍘嗭紙闃村巻锛夛紝闃村巻鏈堜唤姣斿お闃虫湀浠界煭銆傚洜姝わ紝姣忛殧鍑犲勾锛屼粬浠氨浼氬鍔犱竴涓湀銆?/p>
4. 澶╂暟鏄繛缁殑锛?/strong>
鍝﹀摝鍝︼紝鏄殑锛岀湅涓婁釜渚嬪瓙鐨勫浘锛屼綘浼氬彂鐜?鏈堢殑澶╂暟骞朵笉鏄繛缁殑銆?/p>
杩樻湁璁稿鍏朵粬渚嬪瓙銆傛瘡娆′竴涓浗瀹?鍦板尯鏇存敼鍏舵棩鍘嗘椂锛岃繖浜涙棩瀛愬彲鑳戒笉鏄繛缁殑銆?/p>
5. 闂板勾姣?骞翠竴娆★紵
杩欎釜浼拌绋嬪簭鍛樹滑閮界煡閬撲簡锛?/p>
骞翠唤蹇呴』鑳借 4 鏁撮櫎锛屽鏋滃勾浠戒篃鍙互姝ｉ櫎浠?00锛岄偅灏变笉鏄棸骞达紝闄ら潪骞翠唤涔熻兘琚?400 鏁撮櫎锛岃繖鏍锋墠鏄棸骞淬€?/p>
1900骞翠笉鏄棸骞?/strong>
2000骞存槸闂板勾
2025骞存槸闂板勾
鏈変簡涓婅堪瑙勫垯锛屼换浣曚汉閮藉彲浠ユ纭绠楅棸骞淬€?/p>
6. 鏍兼灄濞佹不鏍囧噯鏃堕棿(GMT)涓庝笘鐣屾爣鍑嗘椂闂寸浉鍚?UTC)涓€鏍峰悧锛?/strong>
UTC鏄浗闄呰閲忓眬锛圔IPM锛夋帹鑽愪綔涓烘椂闂存硶寰嬩緷鎹殑鍥介檯鏃堕棿灏哄害銆?/p>
鏍兼灄濞佹不鏍囧噯鏃堕棿 锛圙MT锛?鏄竴涓椂鍖猴紝鏄鸡鏁︽牸鏋楀▉娌荤殗瀹跺ぉ鏂囧彴鐨勫钩鍧囧お闃虫椂銆傚畠瀵瑰簲浜嶶T1銆?/p>
UTC鍜孏MT涔嬮棿鐨勬椂闂村樊鍦ㄥ嚑鍒嗕箣涓€绉掑唴銆傚洜姝わ紝閫氬父杩欎袱涓椂闂磋璁や负鏄浉鍚岀殑銆傞櫎闈炰綘鏄互绉戝鐮旂┒涓虹洰鐨勭殑銆?/p>
7. 鏃跺尯鍋忕Щ閲忓缁堜负鏁存暟锛?/strong>
璁稿鏃跺尯涓嶆槸鏁村皬鏃躲€備緥濡傦紝绾借姮鍏板浠ゆ椂鏄?UTC-2锛?0銆傛境澶у埄浜氫腑瑗块儴鏍囧噯鏃堕棿鏄疷TC+8锛?5銆?/p>
8. 鏃跺尯鍋忕Щ閲忎粙浜?-12 灏忔椂鍜?+12 灏忔椂涔嬮棿锛?/strong>
鑾辨仼缇ゅ矝锛圠ine Islands锛夋椂闂存槸UTC+14
9. 澶忎护鏃?DST)濮嬬粓涓?-1 鎴?+1 灏忔椂锛?/strong>
澶忎护鏃舵境澶у埄浜?Lord_Howe鏄?30 鍒嗛挓銆傚湪Antartica/Troll锛屽亸绉婚噺涓?2 灏忔椂銆?/p>
鍦⊿ql Server 2016涓婏紝鍙互浣跨敤sys.time_zone_info锛屾煡璇㈢壒瀹氭椂鍖哄綋鍓嶆槸鍚﹀湪DST涓?/p>
select * from sys.time_zone_info
绀轰緥缁撴灉
name current_utc_offset is_currently_dst
Aleutian Standard Time -09:00 1
Hawaiian Standard Time -10:00 0
Marquesas Standard Time -09:30 0
Alaskan Standard Time -08:00 1
10. 澶忎护鏃跺湪姣忎釜鏃跺尯鍚屾椂鍙戠敓?
鏅哄埄鐨勫浠ゆ椂浠庡崍澶滃紑濮嬨€?/p>
鍦ㄧ編鍥?澶氫鸡澶氾紝澶忎护鏃朵粠鍑屾櫒 2 鐐瑰紑濮嬨€?/p>
鍦ㄦ娲?宸撮粠锛屽浠ゆ椂浠庝笁鏈堢殑鏈€鍚庝竴涓槦鏈熸棩寮€濮嬨€?/p>
鍦ㄧ編鍥?澶氫鸡澶氾紝澶忎护鏃朵粠涓夋湀鐨勭浜屼釜鏄熸湡鏃ュ紑濮嬨€?/p>
濡傛灉浣犻噰鐢⊿ql Server浣滀负浣犵殑鏁版嵁搴擄紝閭ｄ箞鍙互浣跨敤瀹冪殑鏂拌娉曡浆鎹㈠浠ゆ椂銆?/p>
inputdate AT TIME ZONE timezone
涓嶈繃杩欏浼欐€ц兘寰堝樊锛屽垏璁板垏璁伴锛?/p>
11. 涓€涓浗瀹?鍦板尯涓殑鎵€鏈夋椂鍖洪兘閬靛畧澶忎护鏃?/strong>
鍦ㄥ姞鎷垮ぇ锛岃澶氭椂鍖洪兘閬靛畧澶忎护鏃讹紝浣嗘槸鑲茬┖鍦板尯锛堢編鍥?鍏嬮浄鏂】锛夋病鏈夊浠ゆ椂鏃堕挓鍙樺寲銆?/p>
浠庣▼搴忓憳瑙掑害鐪嬶紝涓浗鍙栨秷澶忎护鏃讹紝鐪熸槸鏄庢櫤涔嬩妇锛?/p>
12. 鏃ユ湡鏃堕棿 + 鏃跺尯琛ㄧず鍗曚釜鏃堕棿鐐癸紵
澶忎护鏃跺彲浠ュ皢鏃堕挓鍚戝悗绉诲姩锛屽洜姝ゅ畠鍙互琛ㄧず涓や釜涓嶅悓鐨勬椂鍒汇€?/p>
13. 鍚屼竴鏈堜唤鍦ㄤ换浣曞湴鏂归兘鏈夌浉鍚岀殑澶╂暟锛?/strong>
鍦ㄧ憺鍏革紝February 30th 1712鏈夋晥銆?/p>
14. 1 鍒嗛挓 = 60 绉?
鐢变簬姘斿€欏拰鍦拌川浜嬩欢鐨勫奖鍝嶏紝 鍦扮悆鐨勮嚜杞懆鏈熼殢鏃堕棿鑰屽彉鍖栥€傞€氬父锛屾瘡闅斿嚑骞村彉鍖栫害涓轰竴绉掗挓銆?/p>
姣忓綋鍘熷瓙鏃堕棿鐨勫彉鍖栧彉寰楀お澶ф椂锛屽氨浼氭彃鍏ヤ竴绉掔殑鏍℃锛岀О涓洪棸绉掞紝杩欐牱鍋氱殑鏂瑰紡鏄樊寮傛案杩滀笉浼氳秴杩?0.9 绉掋€?/p>
渚嬪锛?code>June 30th, 2012 11:59:60 PM鏄湁鏁堟椂闂?
鍦╓indows Server 2016涔嬪墠锛屽井杞椂闂存湇鍔′笉鐭ラ亾闂扮锛岃€屾槸渚濋潬澶栭儴鏃堕棿鏈嶅姟鏉ュ鐞嗚繖涓棶棰樸€備笉杩囩幇鍦ㄧ殑Windows绯荤粺锛岀煡閬撻棸绉掍簡銆?/p>
15. 涓€澶╂槸 24 灏忔椂锛?/strong>
鏃ユ湰鍦?1948-1951 骞村疄鏂藉浠ゆ椂锛屼絾鏄紝浠栦滑浣跨敤鐨勭瓥鐣ヤ笌鍏朵粬鍥藉瀹屽叏涓嶅悓銆備粬浠彧鏄湪涓€澶╃粨鏉熸椂娣诲姞涓€涓皬鏃讹細
Saturday 23:58
Saturday 23:59
Saturday 24:00 (no change of date)
Saturday 24:01
...
Saturday 24:58
Saturday 24:59
Sunday 00:00
Sunday 00:01
16. 涓€涓浗瀹舵湁 1 涓椂鍖猴紵
涓€涓浗瀹?鍦板尯鍙互鏈夊涓椂鍖恒€?/p>
渚嬪锛屼腑鍥藉箙鍛樿窘闃旓紝鎸夊浗闄呴€氳鏃跺尯鍒掑垎鏍囧噯鍙垝鍒嗕负 涓滀簲鍖?銆?涓滃叚鍖?銆?涓滀竷鍖?銆?涓滃叓鍖?銆?涓滀節鍖?5涓?鏃跺尯 銆?/p>
17. 璁＄畻涓や釜鏃ユ湡涔嬮棿鐨勫ぉ鏁板緢绠€鍗曪紵
鐢变簬鏃跺尯鍜屾棩鍘嗙殑鍙樺寲锛岃绠?2 涓棩鏈熶箣闂寸殑澶╂暟鍙兘闇€瑕佷竴浜涢澶栫殑閫昏緫銆?/p>
渚嬪鎮ㄥ浣曞鐞嗚嫳鍥藉浠ゆ椂 1752 骞?鎴栧お骞虫磱/闃跨毊浜?2011 骞寸己澶卞ぉ鏁扮殑鎯呭喌锛?/p>
18. 浠?UTC 鏍煎紡瀛樺偍鏃ユ湡鍙槻姝㈡墍鏈夐棶棰橈紵
濡傛灉浣犳兂鎶婃槑骞寸殑浼氳瀹夋帓鍦ㄧ航绾︿笂鍗?0鐐癸紝浣犱笉搴旇璁＄畻UTC鏃ユ湡骞跺瓨鍌ㄥ畠銆?/p>
浜嬪疄涓婏紝鎮ㄦ棤娉曠‘瀹?DST 鐨勮鍒欏湪浼氳涔嬪墠涓嶄細鏇存敼銆?/p>
浣滆€呮敞:澶忎护鏃舵槸涓€涓斂绛栦笂鐨勪笢涓滐紝鍒寚鏈涘畠寰堢鍚堜互寰€鐨勮鍒欙紒
19. 鏈哄櫒涔嬮棿鐨勫悓姝ユ椂闂村緢瀹规槗锛?/strong>
鍚屾鏃堕棿鍦ㄥ垎甯冨紡绯荤粺涓彲鑳藉緢閲嶈锛岀綉缁滄椂闂村崗璁紙NTP锛夊崗璁厑璁稿湪鏈哄櫒涔嬮棿鍚屾鏃堕棿銆備絾鏄湁澶氱鍥犵礌浼氫娇鑾峰緱鍑嗙‘鐨勬椂闂村彉寰楀洶闅撅細
NTP 鏈嶅姟鍣ㄥ彲鑳戒笉鍑嗙‘
缃戠粶鍙兘鎷ュ
缃戠粶鍙兘涓嶆槸瀵圭О鐨勶紙鍚戞湇鍔″櫒鍙戝嚭鐨勮姹傜殑璺冪偣鏁颁笌鍝嶅簲鐨勮穬鐐规暟涓嶅悓锛?/p>
鏈哄櫒鏃堕挓鍙兘涓嶅噯纭?/p>
缁撹
濡傛灉鎮ㄧ殑搴旂敤绋嬪簭闇€瑕佸鐞嗘棩鏈熷拰鏃堕棿锛岃鍔″繀浜嗚В鎮ㄧ殑搴旂敤绋嬪簭鐨勮姹傘€?/p>
澶у鏁版儏鍐典笅锛屾偍鍙互闄愬埗闇€瑕佹敮鎸佺殑鑼冨洿锛侊紒
渚嬪锛屾偍鐨勫簲鐢ㄧ▼搴忔槸鍚﹂渶瑕佷负闂扮銆侀仴杩滅殑鍘嗗彶鏃ユ湡鎴栧涓椂鍖鸿€岀儲鎭硷紵濡傛灉浣犺兘缂╁皬鑼冨洿锛屽疄鐜板氨浼氱畝鍗曞緱澶氾紝浣犲彲鑳戒笉蹇呰垂蹇冨幓鍏虫敞鏃ユ湡鍜屾椂闂寸殑鎵€鏈夌粏鑺傦紒
馃憮閮芥敹钘忎簡锛岃繕鍦ㄤ箮涓€涓瘎璁哄悧锛?/p>
