OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Constructing query to display item count based on increments of time

From: Pascual Strømsnæs (pascualegoria.no)
Date: Wed Oct 06 2010 - 05:20:49 CDT

Hi!

How would one go about to construct a query that counts items within an
increment or span of time, let's say increments of 10 minutes?
Imagine a simple table where each row has a timestamp, and the query
should return the count of items occurring within the timespan of a
defined period.

Say,

09:00: 14
09:10: 31
09:20: 25
09:30: 0
09:40: 12

etc.

I have been able to get collections of item occurrence based on month
and day by using GROUP BY together with a DATE_FORMAT( start_time, "%d
%m %Y" ) eg.
I can however not seem to be able to find the solution to grouping based
on the minute increments in my example above.

Any suggestions?

--
Kind regards

Pascual Strømsnæs

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql