Week Date SQL QUERY

[MuraliDharan V]

Dear Experts,

I need to get the week start date and end date for the given month.
If my Input Month is AUGUST,then I need the output as

Quote


-----------------------------------------------------------------------------------|
|WEEK1(MON-SAT) | WEEK2(MON-SAT) | WEEK3(MON-SAT) | WEEK4(MON-SAT) |
-----------------------------------------------------------------------------------|
|5-AUG TO 10-AUG | 12-AUG TO 17-AUG | 19-AUG TO 24-AUG | 26-AUG TO 31-AUG|
-----------------------------------------------------------------------------------|

Thanks,
Murali.V