mysql> select date_sub(curdate(), interval 1 day) as wibble; +------------+ | wibble | +------------+ | 2003-06-30 | +------------+ 1 row in set (0.00 sec)
-----Original Message----- From: Fabio Bernardo [mailto:[EMAIL PROTECTED] Sent: Tuesday 01 July 2003 15:32 To: Mysql (E-mail) Subject: date format today´s date: 2003-07-01 Hi there,,, I wrote down this statement select (current_date - 1 ) and the result was: -------------------- (Currentdate -1) ------------------- 20030700 when i write select (current_date ) I have: -------------------- (Currentdate) ------------------- 2003-07-01 but actually, I wanna a result like that.... select (current_date - 1 ) as result -------------------- (Currentdate -1) ------------------- 2003-06-30 can you help me, please? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]