Re: AAAAGGGHHHH!!! Help!!
| From: | Alister | Date: | Fri, 11 Jul 2003 21:02:49 +0000 |
| Subject: | Re: AAAAGGGHHHH!!! Help!! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-154932@lists.php.net to get a copy of this message | ||
On Fri, 11 Jul 2003 16:41:06 -0400
"Mike Mannakee" <mike@basementideas.com> wrote:
> I am running a query in mysql :
> ... WHERE
> visitors.created > DATE_SUB( CURRENT_DATE, INTERVAL 1 HOUR )
> AND > id = pixeldata_.remote > GROUP BY > visitors.id
CURRENT_DATE now( ) DATE_SUB( CURRENT_DATE, INTERVAL 1 HOUR )
2003-07-11 2003-07-11 22:02:02 2003-07-10 23:00:00
I think you'd want:
DATE_SUB( NOW( ) , INTERVAL 1 HOUR )
2003-07-11 21:02:02
Alister