Use datetime to store dates in the range from January 1, 1753 through December 31, 9999 (requires 8 bytes of storage per value). Use smalldatetime to store dates in the range from January 1, 1900 through June 6, 2079 (requires 4 bytes of storage per value).
用Varchar、Char,存储的时候不要时间。或者
用Datetime型,查询的时候转换一下
Select Convert(Char(10),GetDate(),120)
Select Convert(VarChar(10),GetDate(),120)
smalldatetime 就行的。
只要你保存的时候把日期转换一下就可以了
Select Convert(VarChar(10),GetDate(),120)