Mysql-59412

SELECT CONVERT(DATE_FORMAT(DATETIME,'%H'),signed integer) as HOUR,COUNT(*) AS COUNT
from ANIMAL_OUTS
group by HOUR
having HOUR>=9 and
HOUR<20
order by HOUR asc;

CONVERT
->문자열을 정수로 변환