ORA-01843 Not a valid month
Always be specific when you have dates formatted as text: do the conversion explicitly with the correct date/time format for your data. to_date(’14/04/2015′, ‘DD/MM/YYYY’) Do that for all date inputs.
Always be specific when you have dates formatted as text: do the conversion explicitly with the correct date/time format for your data. to_date(’14/04/2015′, ‘DD/MM/YYYY’) Do that for all date inputs.
The problem is that replace(“st”, “”) also removes the st ending of August, resulting in the input string seen in the error message. To handle this, you need to make sure the st suffix is right after a digit, so it’s part of the day value. You also need to handle all of 1st, 2nd, … Read more