datename method in sqlserver

Question

how to show the day (like : sunday,monday ...) in sql query i write like this

select datename(day,getdate())

but it give numaric values but i want sunday,monday,tuesday..... please give some soulution

Answer 1

try datename(weekday, getdate())

Answer 2

or datename(dw,getdate())

Answer 3

DATENAME ( datepart, date )

MSDN DATENAME

e.g.

SELECT DATENAME(weekday,getdate())

Answer 4

SELECT DATENAME(weekday, GETDATE())