-
create table #
(
id int identity (1,1),
a smalldatetime
)
insert #
select '2008-12-23 21:15:50.253'
union all select '2008-12-23 21:15:30.000'
union all select '2008-12-23 21:15:29.253'
union all select '2008-12-23 21:15:29.999'
union all select '2008-12-23 21:15:00.000'select * from #
/******************************id a----------- -----------------------1 2008-12-23 21:16:002 2008-12-23 21:16:003 2008-12-23 21:15:004 2008-12-23 21:16:005 2008-12-23 21:15:00
(5 row(s) affected)
******************************/
按我們的理解應該是結果為2008-12-23 21:15:50,可實際結果卻是2008-12-23 21:16:00
原來時間也是可以二舍三入的