Getting next monday to next sunday parameters value in sql server

Getting next monday to next sunday parameters value

Use the following query to obtain the next monday to sunday dates. 

 

select dateadd(week, datediff(week, 0, getdate()), 7) as NextMonday, dateadd(week, datediff(week, 0, getdate()), 13) as Nextsunday

 

Getting next monday to next sunday parameters value in sql server was last modified: January 26th, 2018 by Justin Antony