Get day of week in SQL Server 2005/2008 June 18, 2022 by Tarik Use DATENAME or DATEPART: SELECT DATENAME(dw,GETDATE()) -- Friday SELECT DATEPART(dw,GETDATE()) -- 6