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?
datetimesqlsql server
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?
Best Answer
Use
DATENAME
orDATEPART
: