Get the day from date value in SQL Server
October 29th, 2009
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]