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_DATEnow( ) DATE_S
I am running a query in mysql :
SELECT DISTINCT (id) AS visitor_id,
MAX(date_time) AS last,
MIN(date_time) AS first,
UNIX_TIMESTAMP( MAX(date_time)) -
UNIX_TIMESTAMP( MIN(date_time)) AS diff
FROM visitors, pixeldata_
WHERE
visitors.created > DATE_SUB( CURRENT_DATE, INTERVAL 1 HOUR )
AND
id = pixel
2 matches
Mail list logo