Hi,
We have a dml error logging table whereby we are looking to insert into a table and log any errors into a dml error logging table.
However, when try and insert into table get ORA-01487: day of month must be between 1 and last day of month
expression below.
TO_DATE( <table.column_name> ,'DD/MM/YYYY HH24:MI')
Guessing cannot use dml error logging for this.
Is there a way can pre-process the data to look for any rows which have an invalid date column?
Not sure of expression could use to identify rows which have invalid date - any thoughts/ideas is there an invlaid date oracle function?
Thanks