You can do this like so:

select hour(date_time) as hour, count(*) from test where date(date_time) = date(now()) group by hour(date_time);

Bert