34,594
社区成员
发帖
与我相关
我的任务
分享
DECLARE @TargetDate DATETIME=GETDATE();
DECLARE @DaySpan INT=-1;
SELECT @DaySpan=CASE DATEPART(WEEKDAY,DATEADD(DAY,@DaySpan,@TargetDate))
WHEN 1 THEN @DaySpan-1
ELSE @DaySpan END
SELECT DATEADD(DAY,@DaySpan,@TargetDate)