Problem:
When trying to convert the char column (attribute9) to date using the to_date function in SQL Developer, the following error is displayed:
ORA-01843: not a valid month 01843. 00000 - "not a valid month" *Cause: *Action:
Solution:
Dates were stored in two different formats (mm/dd/yyyy) and (dd-mon-yyyy) in the attribute9 column. Convert all dates to one format (dd-mon-yyyy).
0 Comments.