On 1 Jul 2003 at 11:31, Fabio Bernardo wrote:
> select (current_date - 1 )
>
> and the result was:
> --------------------
> (Currentdate -1)
> -------------------
> 20030700
Use this instead:
SELECT CURRENT_DATE() - INTERVAL 1 DAY;
The documentation for DATE_ADD() and other date and time functions
is here:
http://www.mysql.com/doc/en/Date_and_time_functions.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
