select txtdate from table where txtdate is not null and TO_DATE(txtdate, 'DD/MM/YYYY') <= trunc(sysdate)

select * from (
       select txtdate from table where txtdate is not null
) t where TO_DATE(txtdate, 'DD/MM/YYYY') <= trunc(sysdate)