SQL DAYNAME() Function

SQL DAYNAME() Syntax

The below syntax is used to extract specified dayname of the week from given a input date value.

For SQL SERVER / MY SQL

SELECT DAYNAME('valid_date_value');

For MS Access

SELECT WEEKDAYNAME(valid_integer_number);

SQL DAYNAME() Example - Using Expression Or Formula

The following SQL SELECT statement will extract the day of week value from a given input date value. We use now() function to get the input date value.

For SQL SERVER / MY SQL

SELECT 
NOW() AS 'Current Date and Time', 
DAYNAME(NOW()) AS 'Day Name';

For MS Access

SELECT 
NOW() AS 'Current Date and Time', 
WEEKDAYNAME(WEEKDAY(NOW())) AS 'Day Name';

Note: the WEEKDAY() function returns a integer (between 1 and 7) containing a whole number representing the day of the week.

The result of above query is:

Sample Database Table - BookOrder

SQL DAYNAME() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate", from the "BookOrder" table. The DAYNAME() function will extract the dayname of week from the column "OrderDate" and we will stored that value to a new column called "Day Name From OrderDate".

For SQL SERVER / MY SQL

SELECT OrderDate, 
DAYNAME(OrderDate) As 'Day Name From OrderDate'
FROM BookOrder;

For MS Access

SELECT OrderDate, 
WEEKDAYNAME(WEEKDAY(OrderDate)-1) AS 'Day Name From OrderDate'
FROM BookOrder;

The result of above query is: