Handling invalid Dates In query for Invalid dates in date column.
791722Sep 15 2010 — edited Sep 16 2010Hi,
I have a date column in my table. This column has corrupted data so the when i use any
to_timestamp function or any other date calcualtions my query breaks with the error:
ORA-01843: not a valid month.
I am aware the data is the issue.
But i want to handle this scenario by putting nulls in the output when ever an invalid date is encountered.
I have done some research and found the custom function is_date() on net.
But i am not suppose to create any new function but handle it with in my query.
Help is appreciated to handle this scenario.