Home Forums SQL Server 2008 SQL Server Newbies Week Mon thru sunday RE: Week Mon thru sunday
Lynn Pettis
SSC Guru
Points: 442467
More actions
September 2, 2015 at 11:06 am
#1824086
Taking a guess I would say this:
declare @CurDate date = getdate();
select
dateadd(week, datediff(week, 0, @CurDate) - 2, 0),
dateadd(day, 6, dateadd(week, datediff(week, 0, @CurDate) - 2, 0))