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
l [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 01, 2002 4:05 PM
> To: [EMAIL PROTECTED]
> Subject: using currentdate in queries
>
>
> We run many queries for data for the previous day..
>
> select foo from blah where date=(Current_Date)-1;
>
> Since it was just
We run many queries for data for the previous day..
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. I looked through the manual but I didn't find an answer. (I
probably just looked over the right part)
Does an
