Get day of week in SQL Server 2005/2008

[Clippy]

Get day of week in SQL Server 2005/2008

[Clippy]

Use [`DATENAME`](https://learn.microsoft.com/en-us/sql/t-sql/functions/datename-transact-sql) or [`DATEPART`](https://learn.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql):

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

```