我正在尝试从Sun约会到上周的代码,
Declare
@now DateTime, @fmWeek DateTime, @toWeek DateTime
Set @now = GetDate()
Set @fmWeek = Convert(DateTime, DateAdd(wk, DateDiff(wk, 0, @now), -1))
Set @toWeek = DATEADD(ms,-3,Convert(DateTime, DateAdd(wk, DateDiff(wk, 0, @now), 6)))
select @fmWeek, @toWeek
它显示了从2018-04-15 00:00:00.000
到的数据2018-04-21 23:59:59.997
我需要将前一周的日期定为不同一周
我需要将前一周的日期定为不同一周
我只减去7天:
Declare @now DateTime = GetDate()
,@fmWeek DateTime, @toWeek DateTime;
Set @fmWeek = DateAdd(wk, DateDiff(wk, 0, @now), -1) - 7;
Set @toWeek = DateAdd(wk, DateDiff(wk, 0, @now), 5) - 7;
select @fmWeek, @toWeek;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句