Get day of week in SQL Server 2005/2008

Posted By: aaaa

If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc…

Is there a built-in function for this in SQL Server 2005/2008? Or do I need to use an auxiliary table?

Solution

Use DATENAME or DATEPART:

SELECT DATENAME(dw,GETDATE()) -- Friday
SELECT DATEPART(dw,GETDATE()) -- 6

Answered By: Anonymous

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.