T-SQL – How to output day name from date

The following T-SQL statement shows how output the name of a day from a date.

For example, 16 March 2019 would output Saturday.

SELECT DateName( weekday , GETDATE() ) as Day_Name_From_Date

Was this article helpful?

Related Articles