ORA-01840: input value not long enough for date format

I'm trying to perform a select query on an oracle database but I get this error.

ORA-01840: input value not long enough for date format

My query is:

SELECT * FROM TIGER.VIEW_TNW_MAINSTREAM WHERE TO_CHAR(SYSDATE,'yyyy/mm/dd') =
TO_CHAR(TO_DATE(DUE_DATE,'yyyy/mm/dd')-5,'yyyy/mm/dd')

Does anyone know what's wrong?

When I do:

SELECT TO_CHAR(SYSDATE,'yyyy/mm/dd') FROM TIGER.VIEW_TNW_MAINSTREAM

and

SELECT TO_CHAR(TO_DATE(DUE_DATE,'yyyy/mm/dd')-5,'yyyy/mm/dd') FROM TIGER.VIEW_TNW_MAINSTREAM i get no errors.

Would it be the fact that I have NULL values in the DUE_DATE field?

Thanks in advance for any help.

Tim :-) Received on Sun Nov 16 2003 - 02:53:29 CET