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

https://www.plus2net.com/sql_tutorial/date-monthname.php By using any date and input, we can get full month name SELECT MONTHNAME(‘2020-09-21’); We can get present month name in full by using CURDATE() function SELECT MONTHNAME(CURDATE()); We can also get Previous Month name SELECT MONTHNAME(CURDATE()-INTERVAL 1 MONTH); Next month name in full SELECT MONTHNAME(CURDATE() + INTERVAL 1 MONTH); Last month , current month and next month SELECT MONTHNAME(CURDATE()- interval 1 month) as LastMonth, MONTHNAME(CURDATE()) as PresentMonth, MONTHNAME(CURDATE()+ INTERVAL 1 Month) as NextMonth