extract month name from dateMYSQL code example

Example 1: mysql month name extract

SELECT MONTHNAME(column_date,’%m’)) as monthname from tablename;

Example 2: extract month from date in mysql

MONTH(date)