SUBSTR(TRAN_DTIME, 1, 8)) OR (MSG_FLAG = 'C' AND MSG_ID IN ('NIG020331','NIG020332','NIG020530','NIG020650')) ]]> SUBSTR(TRAN_DTIME, 1, 8) ]]> SUBSTR(TRANS_DTIME, 1, 8) ]]> 3 ]]> 1 ]]> 3 ]]>