SQL MONTHNAME() Function

SQL MONTHNAME() Syntax

The below syntax is used to extract full name of the specified month from given a input date value.

For SQL SERVER / MY SQL

SELECT MONTHNAME('valid_date_value');

For MS Access

SELECT MONTHNAME(valid_integer_number);

SQL MONTHNAME() Example - Using Expression Or Formula

The following SQL SELECT statement will extract full name of the specified month 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', 
MONTHNAME(NOW()) AS 'Month Name';

For MS Access

SELECT 
NOW() AS 'Current Date and Time', 
MONTHNAME(MONTH(NOW())) AS 'Month Name';

Note: the MONTH() function returns a integer specifying a whole number between 1 and 12, inclusive, representing the month of the year.

The result of above query is:

Sample Database Table - BookOrder

SQL MONTHNAME() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate", from the "BookOrder" table. The MONTHNAME() function will extract the fullname of the specified month from the column "OrderDate" and we will stored that value to a new column called "Month Name From OrderDate".

For SQL SERVER / MY SQL

SELECT OrderDate, 
MONTHNAME(OrderDate) As 'Month Name From OrderDate'
FROM BookOrder;

For MS Access

SELECT OrderDate, 
MONTHNAME(MONTH(OrderDate)) AS 'Month Name From OrderDate'
FROM BookOrder;

The result of above query is: