Get month of a date
SELECT MONTH(CURRENT_DATE); /* mysql> SELECT MONTH(CURRENT_DATE); +---------------------+ | MONTH(CURRENT_DATE) | +---------------------+ | 10 | +---------------------+ 1 row in set (0.00 sec) */