mysql> mysql> SELECT DAYNAME('2006-05-00'); +-----------------------+ | DAYNAME('2006-05-00') | +-----------------------+ | NULL | +-----------------------+ 1 row in set, 1 warning (0.00 sec) mysql>