how to get month data in mysql code example

Example 1: mysql extract month from date

SELECT MONTH(field_name) as month FROM yourtable

Example 2: extract month from date in mysql

MONTH(date)