On 1 May 2002, at 13:04, Jeff O'Neal wrote:
> select foo from blah where date=(Current_Date)-1;
>
> Since it was just the end of the month that ended up giving us a blank
> result set.
WHERE date = CURRENT_DATE - INTERVAL 1 DAY
see http://www.mysql.com/doc/D/a/Date_and_time_functions.html
[Fi
You'll probably want to use SUBDATE instead.
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
> -Original Message-
> From: Jeff O'Neal [mailto:[EMAIL P
