SQL持續時間

SET @StartTime=getdate()

WAITFOR DELAY '00:00:03'

SET @Duration=DATEDIFF(ss,@StartTime,getdate())

SELECT @hh=FLOOR(@Duration/60.0/60.0) % 60
SELECT @mm=FLOOR(@Duration/60.0) % 60
SELECT @ss=@Duration % 60