CODEWITHSUNDEEP
sqlsql-servert-sql
Macho
Macho

Reputation: 3607

How to find Day name?

I have to find the Name of a particular DATE (like Sunday, Monday etc.) in past.
Suppose I have to find Day Name on
2000-1-1
How can I find that ?

Upvotes: 9

Views: 19189

Answers (1)

Amit
Amit

Reputation: 22076

You can use DATENAME function of SQL Server, like this

SELECT DATENAME(dw,'2000-1-1')

Upvotes: 20

Related Questions