取得本月最后一周和前一周的周一日期

最新推荐文章于 2023-01-09 17:39:56 发布

DunDunM

最新推荐文章于 2023-01-09 17:39:56 发布

阅读量460

点赞数

本文链接：https://blog.csdn.net/u011265702/article/details/100770714

版权

/*将本月所有日期插入*/
insert into ThisMonths
(MonthDate)
select convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) day from 
(select substring(convert(varchar,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,GETDATE(),120),1,7)+'%'

/*确定每个日期属于周几*/
update ThisMonths set weekd=datename(weekday, MonthDate)

/*找出最后和前一个周一的日期*/
SELECT  top 2 * from [ThisMonths] where WeekD  = '星期一' order by MonthDate desc