getting monthdate 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)
SELECT MONTH(field_name) as month FROM yourtable
MONTH(date)