I have a field (QINST_VALUE) in my database which holds all sorts:
I am working with the date fields only.
All i am trying to do is find anything 14 days before the QINST_VALUE (as START_OF_LOAN)
WHERE QINST_VALUE between sysdate -14 and sysdate
but im getting the error:
ORA-01840: input value not long enough for date format
01840. 00000 - "input value not long enough for date format"
I have tried converting the date string into a DATE but its not working.
and QINST_VALUE < TO_CHAR(sysdate - 14, 'dd/mm/yyyy')