Reputation: 30313

datename method in sqlserver

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

Upvotes: 0

Answers (4)

Reputation: 187050

SELECT DATENAME(weekday, GETDATE())

Upvotes: 0

Reputation: 8335

DATENAME ( datepart, date )

e.g.

SELECT DATENAME(weekday,getdate())

Upvotes: 1

Reputation: 166396

or datename(dw,getdate())

Upvotes: 1

Reputation: 19627

try datename(weekday, getdate())

Upvotes: 1