try GROUP BY (UNIX_TIMESTAMP(tVH.vDateTime) -
MOD(UNIX_TIMESTAMP(tVH.vDateTime, 300)))
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Date Interval Grouping
> Date: Tue, 26 Mar 2002 19:13:44 -0700
>
> Ok here's what I trying to do. I am t
~!
> Ok here's what I trying to do. I am trying to design a little
browser/ip
> tracking page and I need an SQL statement that will allow me to group
IPs
> that hit the site in 5 minute intervals (well I just want the interval
thing
> to work cuz I'll prolly want to make this like 30 minutes or
Ok here's what I trying to do. I am trying to design a little browser/ip
tracking page and I need an SQL statement that will allow me to group IPs
that hit the site in 5 minute intervals (well I just want the interval thing
to work cuz I'll prolly want to make this like 30 minutes or a full hour).
