Get day of week in SQL 2005/2008

Question

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 2005/2008? Or do I need to use an auxiliary table?

Answer 1

You can use DATEPART or DATENAME like this:

SELECTDATEPART(dw,GETDATE()) – 6

SELECT DATENAME(dw,GETDATE()) – Friday