摘要： 以周为条件：where datediff(day,addtime,getdate())<=7以月为条件：where datediff(day,addtime,getdate())<=31以当前月： where DATEPART(month, addtime)=DATEPART(month, getdate())以24小时：datediff(hh,addtime,getdate())&l... 阅读全文