sql server中datetime和smalldatetime的區(qū)別
當(dāng)前位置：點(diǎn)晴教程→知識(shí)管理交流
→『 技術(shù)文檔交流 』
1、datetime記錄的時(shí)間范圍較長(zhǎng)，1753-01-01到9999-12-31，可以精確到“秒”，它的長(zhǎng)度為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記錄的時(shí)間范圍較短，1900-01-01到2079-6-6，只能到精確到“分”，它的長(zhǎng)度為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 編輯過(guò) |
關(guān)鍵字查詢
相關(guān)文章
正在查詢... 
|
400 186 1886
