On Fri, 11 Jul 2003 16:41:06 -0400 "Mike Mannakee" <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
