SELECT DATE_FORMAT( deteline, "%Y-%m-%d %H" ) , COUNT( * ) 
FROM test
GROUP BY DATE_FORMAT( deteline, "%Y-%m-%d %H" )