é possivel concatenar a data desta maneira

Boa tarde a todos,

gostaria de saber se é possivel concatenar a data do count com o valor da hora que esta na select pois vou ter que fazer varios count, referente a hora

exemplo:

hora | atendidas

16 | 433

17 | 306

18 | 255

SELECT

DATE (timeevent) AS data,

SUBSTR(timeevent, 12,2) as hora,

(SELECT COUNT(*) AS atendidas

 FROM

	asterisk_titan.queue_log

 

 WHERE

	queuename IN (SELECT nomeFila FROM asterisk_titan.nomeFila WHERE idDepartamento = 5365 )

	AND timeevent BETWEEN '2008-10-10 'CONCAT(hora,':00:00') AND '2008-10-10 'CONCAT(hora,':59:59')

 AND event = 'CONNECT') AS atendidas

FROM

asterisk_titan.queue_log

WHERE

queuename IN (SELECT nomeFila FROM asterisk_titan.nomeFila WHERE idDepartamento = 5365 )

AND timeevent BETWEEN '2008-10-10 00:00:00' AND '2008-10-10 23:59:59'

AND event = 'CONNECT'

GROUP BY substr(timeevent,1,10), substr(timeevent,12,2)

ORDER BY timeevent