This is most likely user error but I noticed today that
when I subract 1 from the curdate() function I get a very
interesting result:
mysql select curdate() - 1 from dual;
+---+
| curdate() - 1 |
+---+
| 20101000 |
+---+
1 row in set (0.00 sec)
You're using incorrect syntax for date math. Use:
CURDATE() - INTERVAL 1 day
See the manual for details.
-Original Message-
From: Ted Maas [mailto:tm...@uic.edu]
Sent: Friday, October 01, 2010 7:47 AM
To: mysql@lists.mysql.com
Subject: possible curdate() issue
This is most likely user