ORA-01843: not a valid month

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).

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.