How to get last date of the lastweek in sql? I mean last sunday date using query?
Regardless of the actual DATEFIRST setting, the last Sunday could be found like this:
SELECT DATEADD(day, -1 - (DATEPART(weekday, GETDATE()) + @@DATEFIRST - 2) % 7, GETDATE() ) AS LastSunday
Replace GETDATE() with a parameter @date to get the last Sunday before a particular date.
GETDATE()
@date
548k questions
547k answers
4 comments
86.3k users