如何按SQL时间日期/ unix时间戳聚合/分组php数组？

Question

How to count/group data from array into hours from MySQL timedate format or unix timestamp?

My array:

Array (
    [0] => Array ( 
                [0] => id
                [1] => name 
                [2] => 2013-01-10 00:36:00 
    ) 
    [1] => Array ( 
                [0] => id
                [1] => name 
                [2] => 2013-01-10 00:36:00 
    ) 
)

How to shrink thousands of items like this and agregate them somehow to hours or even days? I just need rough number of rows with given hour in specyfic day.

Answer 1

try SELECT * from table GROUP BY HOUR(date_column) WHERE condition...

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_hour