Hassan Zaheer

There is a nice function available in SQL server to find out the day name for any given date you can use it in your query.

select datename (dw, ‘10/10/2009′) as [day]

SQL SERVER day for date, find day in sql server