Re: time grouping in mysql

2001-11-03 Thread Paul DuBois
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

time grouping in mysql

2001-11-03 Thread Greg Sarsons
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