tambien puede tienes la funcion mysql MONTH(date).
Código:
MONTH(date)
Returns the month for date, in the range 1 to 12.
mysql> SELECT MONTH('1998-02-03');
-> 2
y la funcion mysql YEAR(date)
Código:
YEAR(date)
Returns the year for date, in the range 1000 to 9999.
mysql> SELECT YEAR('98-02-03');
-> 1998