Re: The very first day of march :-) (select (curdate()-1);)

[Daniel Kasak]

Campanella Danilo wrote:

Hi,

Look at what happened today :

mysql> select curdate();
+------------+
| curdate()  |
+------------+
| 2004-03-01 |
+------------+
1 row in set (0.00 sec)
mysql> select (curdate()-1);
+---------------+
| (curdate()-1) |
+---------------+
|      20040300 |
+---------------+
1 row in set (0.00 sec)
mysql>

Until yesterday 

select (curdate()-1); 

worked fine. 

 

Are you sure of that? As far as I know, you have to use a function like 
date_add() or date_sub() to to date addition / subtraction. What you're 
doing is turning 2004-03-01 into the number 20040301 and then 
subtracting 1 from it, giving you 20040300, which is correct.

Dan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]