1.依次查询 最近七天星期几
select datename(weekday,getdate()-6) as a,
datename(weekday,getdate()-5) as b,
datename(weekday,getdate()-4) as c,
datename(weekday,getdate()-3) as d,
datename(weekday,getdate()-2) as e,
datename(weekday,getdate()-1) as f,
datename(weekday,getdate()-0) as g
查询结果:
2.根据月份查询 今天之前的所有数据
with t as (
select convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) date
from (select substring(convert(varchar,dateadd(month,-0,getdate()),120),1,7)+'-01' day) t1,
(select number from MASTER..spt_values WHERE TYPE='P' AND number>=0 and number<=31) t2
where convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) like
substring(convert(varchar,dateadd(month,-0,getdate()),120),1,7)+'%')
select id