Date handling error in SQL Developer
Budget: $10 – $30 USD
Note: I can only extract data and I can not create table or write in the oracle database (SQL Developer).
I have a table which has a DATE field and there are some invalid date such as numbers or string values or invalid dates.
I need to extract data based on different date parameters such as between 1/2/2010 and 31/12/2011 or >01/02/2020 etc.
However, when I use the TO_DATE(mytablename.column, 'DDMMYYYY') > 01/02/2013
It throws out an error because of some invalid date records which are held in the column.
Can you amend the TO_DATE function to ignore the records with invalid or null dates and carry on with the extraction?
Cheers.
I have a table which has a DATE field and there are some invalid date such as numbers or string values or invalid dates.
I need to extract data based on different date parameters such as between 1/2/2010 and 31/12/2011 or >01/02/2020 etc.
However, when I use the TO_DATE(mytablename.column, 'DDMMYYYY') > 01/02/2013
It throws out an error because of some invalid date records which are held in the column.
Can you amend the TO_DATE function to ignore the records with invalid or null dates and carry on with the extraction?
Cheers.