DATEDIFF() 函数返回两个日期之间的时间
SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate 值是1
SELECT DATEDIFF(day,'2008-12-30','2008-12-29') AS DiffDate 值是-1
限制一天之内的数据条件datediff(day,inspectiondatetime,sysdatetime())=0
限制2个小时之内的数据条件datediff(hh,inspectiondatetime,sysdatetime())<=2