mssql day of week code example
Example 1: datepart day of week
SELECT DATENAME(DW,'2007-10-30');
Example 2: sql server convert date to weekday
SELECT DATENAME( DW , GETDATE() );
SELECT DATENAME(DW,'2007-10-30');
SELECT DATENAME( DW , GETDATE() );