Hi everyone,
I'm currently developing an ETL. In my source DB I have the following field F_PET_DATOS_ULTIMA which is a VARCHAR type.
In my target table this field needs to be a DATE type. For this reason, I've done the following:
SELECT NVL(TO_DATE(SUBSTR(F_PET_DATOS_ULTIMA,1,10),'DD/MM/YYYY'),'01/01/1500') FROM TABLE
The picture below, shows the result of running the query above. It works. However, when I put it into my ETL, ODI displays the error ORA-01843: Not a valid month. Any idea?
