Answers for "sql get day of week from day name"

name of today sql

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

get week day from date in sql

SELECT TO_CHAR(your_table.date_colunm, 'DAY')
FROM your_table;

extract weekday from date in sql

SELECT WEEKDAY(date);