34,576
社区成员
发帖
与我相关
我的任务
分享
declare @startime datetime,@endtime datetime
set @endtime=getdate()
set @startime= DATEADD(hour,-2,@endtime)
select @startime
declare @startime datetime,@endtime datetime
set @endtime=getdate()
set @startime= DATEADD(hour,-2,@endtime)
select @startime
declare @startime datetime,@endtime datetime
set @startime= DATEADD(hh,-2,GETDATE())
print @startime
SELECT DATEADD(hour,-2,GETDATE())
SELECT DATEDIFF(hour,-2,GETDATE())