Seeking solution to Data Integration.... where date filed may contain character.
Summary:
Working on data integration and I'm running into an issue where the Date field may contain characters throwing the error "ORA-00911: invalid characters".
Has anyone run into this before and does anyone know of a workaround?
Content (required):
Version (include the version you are using, if applicable):
23.09.68
Code Snippet (add any code snippets that support your topic, if applicable):
CASE
WHEN VALIDATE_CONVERSION(UD2 AS DATE) <> 1 THEN ‘IGNORE’
WHEN UD2 is NULL THEN 'IGNORE'
ELSE TO_CHAR(TO_DATE(UD2, 'yyyymmdd'),'dd-MON-yyyy')
END
0