EXTRACT(type FROM date) 
The EXTRACT() function uses the same kinds of interval type specifiers as DATE_ADD() or DATE_SUB(), but extracts parts from the date rather than performing date arithmetic. 
mysql> SELECT EXTRACT(YEAR FROM  "1999 - 07 - 02 ");
       ->  1999 
mysql> SELECT EXTRACT(YEAR_MONTH FROM  "1999 - 07 - 02   01 : 02 : 03 ");
       ->  199907 
mysql> SELECT EXTRACT(DAY_MINUTE FROM  "1999 - 07 - 02   01 : 02 : 03 ");
       ->  20102