declare @dateValue datetime, @startDay datetime
set @dateValue = CONVERT(varchar(100), GETDATE(), 23) -- 赋需要查询的日期值,不包含时分秒
set @startDay = dateadd(d, CASE WHEN datepart(dw, @dateValue) + @@DATEFIRST > 8 THEN 8 - @@datefirst ELSE 1 - @@datefirst END, dateadd(d, - datepart(dw, @dateValue) + 1, @dateValue))
select *
from Crm_ProCrmBaseData
where enterdate >= @startDay and enterdate < dateadd(d, 7, @startDay) --将数据限制在从周一开始的7天内
order by enterdate -- 按日期升序排列
set @dateValue = CONVERT(varchar(100), GETDATE(), 23) -- 赋需要查询的日期值,不包含时分秒
set @startDay = dateadd(d, CASE WHEN datepart(dw, @dateValue) + @@DATEFIRST > 8 THEN 8 - @@datefirst ELSE 1 - @@datefirst END, dateadd(d, - datepart(dw, @dateValue) + 1, @dateValue))
select *
from Crm_ProCrmBaseData
where enterdate >= @startDay and enterdate < dateadd(d, 7, @startDay) --将数据限制在从周一开始的7天内
order by enterdate -- 按日期升序排列