SELECT T.POLICY_ID,T.POLICY_STATUS
FROM T_POLICY T
WHERE TO_CHAR(T.UPDATE_TIME,'YYYY-MM-DD') = TO_CHAR(SYSDATE,'YYYY-MM-DD')
AND T.POLICY_STATUS='09'
FROM T_POLICY T
WHERE TO_CHAR(T.UPDATE_TIME,'YYYY-MM-DD') = TO_CHAR(SYSDATE,'YYYY-MM-DD')
AND T.POLICY_STATUS='09'