--如果是正好两分钟,那么就这样:select case when datediff(mi,PLAY_TIME,getdate())=2 then 'YES' else 'NO' end--如果是大于两分钟,那么就这样:select case when datediff(mi,PLAY_TIME,getdate())>=2 then 'YES' else 'NO' end
select case when datediff(n,PLAY_TIME,getdate())=2 then 'YES' else 'NO' end as Status from tablename
DATEDIFF ( datepart , startdate , enddate )
查找出即将当前时间与某一条记录中的时间字段如(PLAY_TIME) 比较间隔两分钟的所有记录select * from tbname where convert(varchar(19),PLAY_TIME,120)=convert(varchar(19),dateadd("s",-120,getdate()),120)
from tablename
比较间隔两分钟的所有记录select * from tbname where convert(varchar(19),PLAY_TIME,120)=convert(varchar(19),dateadd("s",-120,getdate()),120)