Select day(monday) in SQL Server

Question

I have a field with dd-mm-yy hh:mm:ss tt

I want to select only the name of the day

I tried datepart() and day()

both gave me 1 to 31.

What I want is Monday, Tuesday and so on..

How to achieve that?

Answer 1

SELECT DATEPART(WEEKDAY, GETDATE())

or

SELECT DATENAME(WEEKDAY, GETDATE())