MONTHNAME() : Full Month name in MySQL

Returns full month name from a date.
Example :
SELECT MONTHNAME('2016-09-25') 
Output is September
DEMO: Select date from Calendar to execute MONTHNAME()
  • Video Tutorial on date function MONTHNAME()


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

To get short month name as Jan, Feb ... you can use Date format.
SELECT date_format(date,'%b') as dt FROM table_name

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 MonthPresentMonthNextMonth

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

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

$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()

Post your comments , suggestion , error , requirements etc here

SQL Video Tutorials

We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2021 All rights reserved worldwide Privacy Policy Disclaimer