Convert Varchar TO_DATE - HELP

[gandolf989]

Try this.

SELECT * 
  FROM SE101
 WHERE TO_DATE(LPAD(E1_VENCTO, 8, '0'), 'DD/MM/RR') >= sysdate;

You don't need to convert sysdate to a date, it is a date.