declare @date datetime
set @date = getdate()
declare @ integer
set @ = 15
select dateadd(week,datediff(week,0,dateadd(week,@-1,dateadd(year,datediff(year,0,@date),0))),0)
,dateadd(week,datediff(week,0,dateadd(week,@,dateadd(year,datediff(year,0,@date),0))),0)-1
set @date = getdate()
declare @ integer
set @ = 15
select dateadd(week,datediff(week,0,dateadd(week,@-1,dateadd(year,datediff(year,0,@date),0))),0)
,dateadd(week,datediff(week,0,dateadd(week,@,dateadd(year,datediff(year,0,@date),0))),0)-1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货