sql - 获取SQL Server 2005/2008中的星期几(Get day of week in SQL Server 2005/2008)

Question

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

(如果我有一个日期01/01/2009，我想知道它是什么日子，例如周一，周二等...)

Is there a built-in function for this in SQL Server 2005/2008?

(SQL Server 2005/2008中是否有内置函数？)

Or do I need to use an auxiliary table?

(或者我需要使用辅助表吗？)

  ask by translate from so

Answer 1

Use DATENAME or DATEPART :

(使用DATENAME或DATEPART ：)

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