MSSQL查询24小时,当天,本周,本月,本年或30天的数据

select * from salesdata where datediff(day,salesday,getdate())=0 --查询当天的数据
select * from salesdata where DateDiff(hh,salesday,getDate())<=24 --查询24小时内的数据
select * from salesdata where datediff(day,salesday,getdate())<=30 --查30天内的数据
SELECT * FROM salesdata WHERE datediff(week,[salesday],getdate())=0 --查询本周内数据,查上周getdate()-7
SELECT * FROM salesdata WHERE datediff(month,[salesday],getdate())=0 --查询本月内数据,查上月getdate()-30
SELECT * FROM salesdata WHERE datediff(year,[salesday],getdate())=0 --查询本月内数据,查上月getdate()-30
select * from salesdata where datediff(day,salesday,getdate())<=30 --查30天内的数据，如果今天以后也有数据也会查出来，因为正常情况下不会上传未来的数据

下面这句是mysql的
select * from salesdata where salesday between DATE(subdate(curdate()-1,date_format(curdate()-1,'%w')-1)) and  DATE(subdate(curdate()-1,date_format(curdate()-1,'%w')-7))