當一個Datetime插入到Samlldatetime型字段時,SQL Server對時間的處理

1. 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:00

   2           2008-12-23 21:16:00

   3           2008-12-23 21:15:00

   4           2008-12-23 21:16:00

   5           2008-12-23 21:15:00

   
   

   (5 row(s) affected)

   
   
   ******************************/

按我們的理解應該是結果為2008-12-23 21:15:50,可實際結果卻是2008-12-23 21:16:00

原來時間也是可以二舍三入的