SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01843: not a valid month

hartford27Feb 5 2018 — edited Feb 5 2018

Hi, I am trying to convert a datetime field to date format i.e. YYYY\MM\DD, I am running into the ORA - 01843 error with this

TO_DATE(Table__1.Start_Time, 'DD-MON-YYYY'). The data for Table__1.Start_Time is:

Wednesday March 01 2017

Wednesday March 03 2017

Thursday March 01 2017

Please help me with this issue.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2018

Added on Feb 5 2018

8 comments

30,489 views