sql server - Getting the starting and ending date of a week when a date is provided in SQL 2008 -

sql server - Getting the starting and ending date of a week when a date is provided in SQL 2008 -

i need starting date , ending date of week when input date .

note: week has start sunday , end saturday

according logic "week starts sunday , ends on saturday"

select "start_of_week" = dateadd(week, datediff(week,0, getdate()),-1); select "end_of_week" = dateadd(week, datediff(week,0, getdate()),5);

sql sql-server sql-server-2008