MySQL CURDATE () - last day of the month

Question

I have some problems with such mysql_query

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

why if yestay is the last day of the month

The result CURDATE()-1is similar to2010-04-00

why not 2010-03-31

+3

Andriy K. Apr 2 '10 at 5:43

2 answers

What about the DATE_ADD function ?

+1

Rhapsody Apr 2 '10 at 5:45

mcabral · Accepted Answer · 2010-04-02T05:47:04+0000

When you mix date and number, the date is considered a number.

Try:

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