–当天: 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 * f… 继续阅读 金沙城中心赌场Sql Server中查询当天,最近三天,本周,本月,最近一个月,本季度的数据的sql语句

网站地图xml地图