Get last week date in sql

Bikesh Srivastava

10y1.9kCode

Today i am going to explain how to get last week date in sql. Suppose i running any procedure and want select date range of last week on each excution,so in case use this type of sql query, this query always return last week date range.

declare @datefrom datetime
declare @dateto datetime

          set @datefrom=DATEADD(day, -((DATEPART(dw, GETDATE()) + @@DATEFIRST) % 7) - 6,
              DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))

            set @dateto=DATEADD(day, -(DATEPART(dw, GETDATE()) + @@DATEFIRST) % 7,
              DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))
Select @datefrom
select @dateto