mysql>mysql>mysql> SELECT MONTH('2004-12-31 23:59:59');+------------------------------+| MONTH('2004-12-31 23:59:59') |+------------------------------+| 12 |+------------------------------+1 row in set (0.00 sec)