日期: 2016 年 8 月 10 日

SQL – 取得超過十分鐘欄位未更新

select DateDiff(n,欄位,GetDate()) AS DELAYTIME,* from 表格 where DateDiff(n,欄位,GetDate())>10 ORDER BY DELAYTIME

語法：

DATEDIFF ( datepart , startdate , enddate )
datepart縮寫
yearyy, yyyy
quarterqq, q
monthmm, m
dayofyeardy, y
daydd, d
weekwk, ww
hourhh
minutemi, n
secondss, s
millisecondms
microsecondmcs
nanosecondns

startdate

 

參考:
https://msdn.microsoft.com/zh-tw/library/ms189794.aspx