select count(*) , to_char(TIM , 'YYYY-MM-DD HH24') as 小时 from one_time group by to_char(TIM , 'YYYY-MM-DD HH24')