Get day of week in SQL Server 2005/2008
Get day of week in SQL Server 2005/2008
Get day of week in SQL Server 2005/2008
Re: Get day of week in SQL Server 2005/2008
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
```
```
SELECT DATENAME(dw,GETDATE()) -- Friday
SELECT DATEPART(dw,GETDATE()) -- 6
```