declare @Start datetime
declare @End datetime
set @Start=DATEADD(wk, DATEDIFF(wk,0,GETDATE()-7), 0)
set @End=DATEADD(wk, DATEDIFF(wk,0,GETDATE()-7), 6)
select @Start as Monday
select @End as Sunday
Showing posts with label How to find the Last week dates from Monday to Sunday in SQL Server. Show all posts
Showing posts with label How to find the Last week dates from Monday to Sunday in SQL Server. Show all posts
Tuesday, August 14, 2012
How to find the Last week dates from Monday to Sunday in SQL Server
declare @Start datetime
declare @End datetime
set @Start=DATEADD(wk, DATEDIFF(wk,0,GETDATE()-7), 0)
set @End=DATEADD(wk, DATEDIFF(wk,0,GETDATE()-7), 6)
select @Start as Monday
select @End as Sunday
Subscribe to:
Posts (Atom)