笔记166 时间差转换

笔记166 时间差转换

--时间差转换
DECLARE
     @dt1 datetime,
     @dt2 datetime
;
SELECT
     @dt1 = '2012-07-27 11:11:00',
     @dt2 = '2012-07-30 21:00:00'
;
SELECT
     diff_day = CONVERT(int, diff),
     diff_time = CONVERT(varchar(10), diff, 108)
FROM(
     SELECT
          diff = @dt2 - @dt1
)AA
;

SELECT diff = @dt2 - @dt1