Sql to get day of week and day of month

 

Declare
@dd datetime;

Set @dd= '2013-08-11'
 
Select
datepart(dw, @dd) as dayofweekCnt , datename(dw, @dd) As dayOfWeekNm,DAY(@dd) AS dayOfMonthCnt