get day of week from date sql string code example

Example 1: name of today sql

SELECT GETDATE() 'Today', DATENAME(weekday,GETDATE()) 'Day Name'
SELECT GetDate() 'Today', DATENAME(dw,GETDATE()) 'Day Name'

Example 2: sql server convert date to weekday

SELECT DATENAME( DW , GETDATE() );