How to find Day name?

I have to find the Name of a particular DATE (like Sunda开发者_运维知识库y, Monday etc.) in past.

Suppose I have to find Day Name on

2000-1-1

How can I find that ?

---

You can use DATENAME function of SQL Server, like this

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