SQL中的时间相加减

select datediff(minute,'2012-05-31 08:03','2012-06-01 08:05') --算出两个时间相差几分钟

SELECT DATEADD(minute,5,'2012-05-01 08:03:01')

select dateAdd(minute,19,'2008-10-25 08:05:31')

select dateAdd(hour,19,'2008-10-25 08:05:31')

select dateAdd(second,19,'2008-10-25 08:05:31')

select dateAdd(day,19,'2008-10-25 08:05:31')

select dateAdd(month,19,'2008-10-25 08:05:31')

select dateAdd(year,19,'2008-10-25 08:05:31')

select cast('2008-10-25 08:05:31'as datetime) +cast(5 as float)/1440

--float 为1时 ，相当与一天