Skip to Main Content

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!

Convert DD-MON-YYYY format to MM/DD/YYYY

1027922Aug 21 2013 — edited Aug 21 2013

I have an input date variable L_DATE as 11-Aug-2013(DD-MON-YYYY).
In my procedure, I am converting the input date to MM/DD/YYYY format .

The logic I have used for the same in my Stored Proc- COMPARE2 is:
R_DATE := to_char(to_date(L_DATE,'DD-MON-YYYY'),'MM/DD/YYYY');

But this is the error that I get when the SP is run:
ORA-01843: not a valid month
ORA-06512: at "COMPARE2", line 51
ORA-06512: at line 2

Can anyone suggest how to resolve this??

This post has been answered by Frank Kulash on Aug 21 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2013
Added on Aug 21 2013
5 comments
15,285 views