MySQL CURDATE() - yesteday is last day of the month

I have开发者_Go百科 some problem whith such mysql_query

INSERT INTO table VALUES ('', CURDATE()-1)

why if yesteday is last day of the month

the CURDATE()-1 result is like 2010-04-00

why not 2010-03-31

When you mix date and number, date is treated as number.

Try:

INSERT INTO table VALUES ('', date_sub(CURDATE(), interval 1 day));

What about the DATE_ADD function?