datename function in sql
I wanted to get the week from the given date, for this I tried with the DATENAME function to get the WEEK like,
   
     Select DateName(WEEK,'2012-03-09')

am getting the output as 10. I want to get the starting date and ending date of this week like, `2012-03-04 to 2012-03-10` Is it possible?
datename function in sql
===

I wanted to get the week from the given date, for this I tried with the DATENAME function to get the WEEK like,
   
     Select DateName(WEEK,'2012-03-09')

am getting the output as 10. I want to get the starting date and ending date of this week like, `2012-03-04 to 2012-03-10` Is it possible?