mysql> mysql> SELECT MONTH('2005-00-00'); +---------------------+ | MONTH('2005-00-00') | +---------------------+ | 0 | +---------------------+ 1 row in set (0.00 sec)