yzf911吧 关注:3贴子:74
  • 0回复贴,共1

计算查询日期所在周前一周的周一到周日日期

只看楼主收藏回复

SET DATEFIRST 1
SELECT @FrWeek=DATEADD(DD,-(DATEPART(WEEKDAY,@UseDate)+6),@UseDate)
SELECT @ToWeek=DATEADD(DD,-(DATEPART(WEEKDAY,@UseDate)),@UseDate)


IP属地:山西1楼2013-09-18 11:47回复