sql server中datetime和smalldatetime的區別
當前位置:點晴教程→知識管理交流
→『 技術文檔交流 』
1、datetime記錄的時間范圍較長,1753-01-01到9999-12-31,可以精確到“秒”,它的長度為8位,所占的空間較大。
datetime: Date and time data from January 1, 1753, to December 31, 9999, wITh an accuracy of three-hundredths of a second, or 3.33 milliseconds. 2、smalldatetime記錄的時間范圍較短,1900-01-01到2079-6-6,只能到精確到“分”,它的長度為4位,所占的空間較小。 smalldatetime: Date and time data from January 1, 1900, through June 6, 2079, wITh an accuracy of one minute. 該文章在 2010/8/27 1:11:05 編輯過 |
關鍵字查詢
相關文章
正在查詢... |