SELECT MONTHNAME('2020-09-30'); SELECT MONTHNAME(CURDATE()); SELECT MONTHNAME(NOW()); SELECT MONTHNAME(CURDATE()-INTERVAL 1 MONTH); SELECT MONTHNAME(CURDATE()+INTERVAL 1 MONTH); SELECT MONTHNAME(CURDATE()-INTERVAL 2 MONTH) as last_month, MONTHNAME(CURDATE()) as this_month, MONTHNAME(CURDATE()+INTERVAL 1 MONTH) as next_month;