如何用时间相减?
declare @a datetime
set @a= getdate()-b
select @b

b为int型参数，时间为秒...

用什么语句?


[解决办法]
declare @a datetime,@b int

set @b =10

set @a= dateadd(mi,@b*-1,getdate())

select @b,@a,getdate()


[解决办法]
declare @a datetime
declare @b int
set @b=10
select dateadd(ss,-10,getdate())


------------------------------------------------------
2007-09-08 13:56:54.420

(1 row(s) affected)