declare
@date datetime
select @date='2019-08-01'
declare @ThisWeekStartTime datetime,@ThisWeekEndTime datetime,
@LastWeekStartTime datetime,@LastWeekEndTime datetime
SELECT @ThisWeekStartTime= CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @date) ), -1),121)--本周开始时间
SELECT @ThisWeekEndTime= CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @date) ), 5),121)--本周结束时间
SELECT @LastWeekStartTime= CONVERT(nvarchar(10),DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -7, @date) ), -1),121)--上周开始时间
SELECT @LastWeekEndTime= CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -7, @date) ), 5),121)--上周结束时间
select @ThisWeekStartTime as ThisWeekStartTime ,@ThisWeekEndTime as ThisWeekEndTime,@LastWeekStartTime as LastWeekStartTime,@LastWeekEndTime as LastWeekEndTime