Answers for "get day of week in sql server"

how to get weekday from old date in sql

select format(columnName, 'dddd') as WeekDay from tableName; -- SQL Server 17

Posted by: Guest on January-14-2021

datepart day of week

SELECT DATENAME(DW,'2007-10-30');

Posted by: Guest on July-20-2020

get week day from date in sql

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

Posted by: Guest on November-15-2020

Code answers related to "get day of week in sql server"