Dear all
I want to know a specific date belongs to which day
For eg:
i want to know 23-01-2010 is monday,tuesday...how to check it?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Krishna GaradPosted Jan 6, 2011, 5:19 AM
http://msdn.microsoft.com/en-us/library/ms174395(SQL.90).aspx
or try this function
SELECT DATENAME(DW, GETDATE()) AS 'Month Name'