how to change day of week name in sql code example Example: sql server convert date to weekday SELECT DATENAME( DW , GETDATE() );