Николай Матюшенков

По часам:
SELECT ... FROM table AS t WHERE ...
GROUP BY DATE(t.date), HOUR(t.date)

По дням:
SELECT ... FROM table AS t WHERE ...
GROUP BY DATE(t.date)

По месяцам:
SELECT ... FROM table AS t WHERE ...
GROUP BY YEAR(t.date), MONTH(t.date)