Aunque no se nada de informix prueba esto
Código SQL:
Ver originalSELECT
DATE(vct_summary.recordtimestamp) AS FECHA,
SUM (vct_summary.numrcvd) AS RECIBIDO,
SUM(vct_summary.numhandled) AS CONTESTADO,
SUM(vct_summary.numabandoned) AS ABANDONADO,
ROUND((100*SUM(vct_summary.svclvlnumerator)/SUM(vct_summary.svclvldenominator) ),0) AS NIVEL_SERVICIO,
ROUND(100*(SUM(vct_summary.numabandoned) / SUM(vct_summary.numrcvd)),0) AS TASA_ABANDONO
FROM
vct_summary vct_summary
WHERE
(vct_summary.compositekey NOT IN ('9999999000000'))
AND recordtimestamp >= datetime(2010-04-01 04:00:00.00) YEAR TO fraction
AND recordtimestamp < datetime(2010-05-01 04:00:00.000) YEAR TO fraction
GROUP BY DATE(vct_summary.recordtimestamp)