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