Skip to Main Content
Forums

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 ERROR

jjkApr 9 2009 — edited Apr 9 2009
Helllo eveyone,
I'm using Oracle 9i and get the "not a valid month" error when executing the below quer

SELECT to_date(to_char(SYSDATE, 'dd/mm/yyyy HH:MI:SS')) FROM DUAL

Please tell me why it's giving me this error

regards,
rossy_rocs
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2009
Added on Apr 9 2009
14 comments
18,409 views