So ...

Freak issue happing now. lol

When I execute using DD/MM/RR (mask) in SELECT clause =
Date: 20110512
Returns: 20/11/12

When I execute using YYYYMMDD (mask) in SELECT clause =
Date: 20110512
Returns: 12/05/11 (right)

But, I use in WHERE clause:
SELECT * FROM SE1010
AND TO_DATE(E1_VENCTO, 'YYYYMMDD') >= sysdate

This error occurs:
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
*Cause: Illegal year entered
*Action: Input year in the specified range

But the year is ok, not exist an invalid year.
Pls, help me ! I need resolve this issue.

Many thanks

Best regards,

Victor Peres