æ ¼å¼ï¼hh:mm:ss[.nnnnnnn]
èå´ï¼00:00:00.0000000 å°23:59:59.9999999
精确度ï¼100 纳ç§
åå¨å¤§å°ï¼ä»¥åè为åä½ï¼ï¼3-5
ç¨æ·å®ä¹çç§çå°æ°ç²¾åº¦ï¼æ
æ¶åºå移éï¼æ
dateï¼
æ ¼å¼ï¼YYYY-MM-DD
èå´ï¼0001-01-01 å° 9999-12-31
精确度ï¼1天
åå¨å¤§å°ï¼ä»¥åè为åä½ï¼ï¼3
ç¨æ·å®ä¹çç§çå°æ°ç²¾åº¦ï¼æ
æ¶åºå移éï¼æ
smalldatetimeï¼
æ ¼å¼ï¼YYYY-MM-DD hh:mm:ss
èå´ï¼1900-01-01 å° 2079-06-06
精确度ï¼1åé
åå¨å¤§å°ï¼ä»¥åè为åä½ï¼ï¼4
ç¨æ·å®ä¹çç§çå°æ°ç²¾åº¦ï¼æ
æ¶åºå移éï¼æ
datetimeï¼
æ ¼å¼ï¼YYYY-MM-DD hh:mm:ss[.nnn]
èå´ï¼1753-01-01 å° 9999-12-31
精确度ï¼0.00333ç§
åå¨å¤§å°ï¼ä»¥åè为åä½ï¼ï¼8
ç¨æ·å®ä¹çç§çå°æ°ç²¾åº¦ï¼æ
æ¶åºå移éï¼æ
datetime2ï¼
æ ¼å¼ï¼YYYY-MM-DD hh:mm:ss[.nnnnnnn]
èå´ï¼0001-01-01 00:00:00.0000000 å°9999-12-31 23:59:59.9999999
精确度ï¼100é ç§
åå¨å¤§å°ï¼ä»¥åè为åä½ï¼ï¼6 å° 8
ç¨æ·å®ä¹çç§çå°æ°ç²¾åº¦ï¼æ
æ¶åºå移éï¼æ
datetimeoffsetï¼
æ ¼å¼ï¼YYYY-MM-DD hh:mm:ss[.nnnnnnn] [+|-]hh:mm
èå´ï¼0001-01-01 00:00:00.0000000 å°9999-12-31 23:59:59.9999999ï¼ä»¥UTC æ¶é´è¡¨ç¤ºï¼
精确度ï¼100é ç§
åå¨å¤§å°ï¼ä»¥åè为åä½ï¼ï¼8 å°10
ç¨æ·å®ä¹çç§çå°æ°ç²¾åº¦ï¼æ
æ¶åºå移éï¼æ