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 on2000-1-1
How can I find that ?You can use DATENAME
function of SQL Server, like this
SELECT DATENAME(dw,'2000-1-1')
精彩评论