SQL Server Queries - Get Name of Day

Getting the Name of the Day in SQL Server

In SQL Server, you can get the name of the day using the `DATENAME` function. Here's how to do it.

Using the `DATENAME` Function

The `DATENAME` function returns a string that represents the specified datepart of a date. In this case, we can use it to get the name of the day.

SELECT DATENAME(dw, GETDATE()) AS DayName; 

This query uses the `GETDATE()` function to get the current date and time, and then passes it to the `DATENAME` function with the `dw` argument, which represents the day of the week. The result is the name of the day.

Example

Let's say we want to get the name of the day for a specific date, such as '2022-07-25'. We can use the following query:

SELECT DATENAME(dw, '2022-07-25') AS DayName; 

The result will be:

Day Name

In this example, the result is 'Monday', which is the name of the day for the date '2022-07-25'.

Getting the Abbreviated Day Name

If you want to get the abbreviated day name, you can use the `FORMAT` function instead:

SELECT FORMAT(GETDATE(), 'ddd') AS DayName; 

This query uses the `FORMAT` function to format the current date and time as a string, using the `ddd` format specifier, which represents the abbreviated day name.

Abbreviated Day Name

In this example, the result is 'Mon', which is the abbreviated day name for the current date.