Posted by Peter van Schie on 11/03/05 01:07

toedipper wrote:

> I have the following select statement whch gives me a count for
> downloads for previous day.
>
> SELECT
> COUNT(swid)
> FROM
> downloads
> WHERE
> date = current_date()-1

Hi toedipper,

I think you're looking for something like this instead:

SELECT CURRENT_DATE() - INTERVAL 1 DAY;

HTH.
Peter.
--
http://www.phpforums.nl

• Next in forum: Compiling PHP Code To Machine Code
• Prev in forum: Re: current_date()-1 misbehaving on first day of month
• Thread view: Re: current_date()-1 misbehaving on first day of month

[Reply to this message]