using datename in sql to get day name from table of given dates code example Example: sql server convert date to weekday SELECT DATENAME( DW , GETDATE() );