extract month name from date mysqlfr language code example Example: mysql month name extract SELECT MONTHNAME(column_date,’%m’)) as monthname from tablename;