How to Get The Day of The Week in SQL Server
In this post we will learn How to Get The Day of The Week in SQL Server. Sometime this is very useful. In earlier post we had discussed How to Password Protected Backup In SQL Server, How To Delete Backup Files Older Than n Days, Creating Resource Pools in SQL Server, Resource Governor in SQL Server.
DATEPART function to calculate the integer value of the day of the week:
SELECT DATEPART(DW,GETDATE()) AS DAYOFWEEKINT
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
DATENAME function to calculate the day of the week:
SELECT DATENAME(DW,GETDATE()) AS DAYOFWEEKCHAR
Get Day of the week for a given date (MM/DD/YYYY) using:
SELECT DATENAME(DW,'07/29/2014') AS DAYOFWEEKCHAR