CODE EXAMPLE FOR SQL

mysql extract month from date

SELECT MONTH(field_name) as month FROM yourtable