Bug #64516 CURDATE() -1 on 1 March of leap year
Submitted: 1 Mar 2012 19:23 Modified: 1 Mar 2012 20:36
Reporter: Frederico Schardong Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:5.1.47 OS:Any
Assigned to: CPU Architecture:Any

[1 Mar 2012 19:23] Frederico Schardong 
Description:
Trying to get yesterday number with CURDATE() - 1 at today (1, March of 2012) I receive 20120300 no even 2012-03-00.

How to repeat:
select curdate() - 1;
[1 Mar 2012 20:29] MySQL Verification Team 
How's this:

mysql> select curdate() - interval 1 day;
+----------------------------+
| curdate() - interval 1 day |
+----------------------------+
| 2012-02-29                 |
+----------------------------+
1 row in set (0.00 sec)
[1 Mar 2012 20:35] MySQL Verification Team 
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add
[1 Mar 2012 20:37] MySQL Verification Team 
See also similar http://bugs.mysql.com/bug.php?id=47140