sql 查询不同时间段的数据

--本周记录(从周日到周六)
SELECT * FROM Work_Tbl WHERE datediff(week,[begindate],getdate())=0
--本周记录(从周一到周日)未完善
--select * from Work_Tbl where DATEDIFF(d,[begindate],GETDATE())>=0 and DATEDIFF(d,[begindate],GETDATE())<5;
--本月记录
SELECT * FROM Work_Tbl WHERE datediff(month,[begindate],getdate())=0
--上月记录
select * from Work_Tbl where DATEDIFF(month,[begindate],GETDATE())=1
--查询上半年数据
select * from Work_Tbl where DATEDIFF(yyyy,[begindate],GETDATE())=0 and MONTH(begindate)<=6
--查询下半年数据
select * from Work_Tbl where DATEDIFF(yyyy,[begindate],GETDATE())=0 and MONTH(begindate)>=7
--查询今年记录
select * from Work_Tbl where DATEDIFF(yyyy,[begindate],GETDATE())=0
--查询去年记录
select * from Work_Tbl where DATEDIFF(yyyy,[begindate],GETDATE())=1