Hello Aurelian,
I do the same thing but use the following code and it works fine.
SELECT @myvar := DATE_SUB( CURRENT_DATE, INTERVAL 1 DAY) ;
Edward
5/1/2001 6:45:19 AM, "Aurelian Dumitru" <[EMAIL PROTECTED]> wrote:
>
>
>Please record the following bug identified on the MySQL server:
>
>1. Hardware: SUN Ultra 10
>2. Operating system: Sun Solaris 2.7
>2. MySQL server version: 3.23.33
>3. Error description:
> - The following SQL statement returns incorrect results when is executed
>using the 'mysql' client: SELECT @myvar := ( CURRENT_DATE - 1) ;
> - I ran this query every day. It worked fine untill May 1st, 2001, when the
>above query returned the following value: 20010500 . It should have returned
>20010430.
>
>Aurelian Dumitru
>[EMAIL PROTECTED]
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php