At 9:02 AM -0500 11/3/01, Greg Sarsons wrote:
>I haven't succeeded in being able to group by time. My timestamp field
>is -mm-dd hh:mm:ss. What I would like is have a query that will
>enable me to be to group on events say every 5 minutes.
>
>I've played around with using time_to_sec(timesta
I haven't succeeded in being able to group by time. My timestamp field
is -mm-dd hh:mm:ss. What I would like is have a query that will
enable me to be to group on events say every 5 minutes.
I've played around with using time_to_sec(timestamp) to convert all the
times to seconds and then gr