= SUBSTR(:1,1,6)||'01000000' AND H02CC.MILL_DTIME <= :2||'235959' AND H02CC.MISSNO_CLF_CD IS NULL GROUP BY SUBSTR(H02CC.MILL_DTIME,1,8) ORDER BY SUBSTR(H02CC.MILL_DTIME,1,8)) T ]]>