摘要：
SQLServer查询最近一天，三天，一周，一月，一季度方法一天"select * from T_news where datediff(day,addtime,getdate())=0";三天"select * from T_news where datediff(day,addtime,getdate())<= 2 and datediff(day,addtime,getdate())>= 0";一周"SELECT * FROM T_news WHERE (DATEPART(wk, addtime) = DATEPART(wk, 阅读全文