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!

Converting Char to Date with a specific format

RoxyrollersFeb 12 2014 — edited Feb 14 2014

Hello folks,

I am trying to convert a Character variable and output it in a specific format:

Parameters I am passing are character strings: Start Date = '01-JAN-2010' and End Date = '31-DEC-2013'. I do however want to output this as January, 2010 - December 2013. I tried TO_DATE(:start_date, 'FMMonth YYYY') but that failed.

Any ideas? No rush on this one -- I am heading home and will check on this tomorrow.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2014

Added on Feb 12 2014

23 comments

18,514 views