MONTHNAME() function to get full name of the month from date in MySQL Query

SELECT MONTHNAME('2023-01-01'); # January
SELECT MONTHNAME('2023-12-31');# December
SELECT MONTHNAME('2023-02-31');# NULL

Returns full month name from a date.
Syntax

MONTHNAME()

Example :

SELECT MONTHNAME('2016-09-25')

Output is September
DEMO: Select date from Calendar to execute MONTHNAME()

MONTHNAME() function to get full name of the month in MySQL

CURDATE() or NOW() & MONTHNAME()

By using CURDATE() we get the present date part only, where as by using NOW() we will get both date and time.

SELECT MONTHNAME(CURDATE())

Output is September

To get short month name as Jan, Feb ... you can use Date format.

SELECT date_format(date,'%b') as dt FROM table_name

Short Month

We can search for matching short months ( three digit month name) like Jan , Feb etc using WHERE condition.

SELECT * FROM `table_name` WHERE DATE_FORMAT(date, '%b')='Jan'

Full Month name

SELECT * FROM `table_name` WHERE DATE_FORMAT( date, '%M' ) = 'January'

Last Month , Today and Next Month

SELECT MONTHNAME(CURDATE()- interval 1 month)  as LastMonth, 
MONTHNAME(CURDATE()) as PresentMonth, 
MONTHNAME(CURDATE()+ interval 1 Month) as NextMonth

Last Month	PresentMonth	NextMonth
August	September	October

PHP Script

To display the above details we used PHP Script, you can use the same script for using all above queries.

config.php connection string is available here

PDO for executing Queries in PHP

How to get records using FETCH() are here

<?Php
require 'config.php';  // Database connection string
$query='SELECT MONTHNAME(NOW()) as dt';
// Change the above Query part to get different results // 

$count=$dbo->prepare($query);
$count->execute();
$row = $count->fetch(PDO::FETCH_OBJ);
echo 'Output is : '.$row->dt; 
?>

SQL Date MONTH() : Month number from 1 to 12
SQL txt file for MONTHNAME()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

MONTHNAME() : Full Month name in MySQL