Here's what I came up with:
select concat(left(DATE_FORMAT(start_time, "%Y-%m-%d %h:%i"
),15),"0") as time, count(*) from table group by time
>> 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
>> 09:00: 14
>> 09:10: 31
>> 09:20: 25
>> 09:30: 0
>> 09:40: 12
>> 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" )
>> 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
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1