= :2 AND substr(C.EXTRACT_DTIME,1,8) <= :3 ]]>