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 Century date to Calendar Date

981321Dec 21 2012 — edited Dec 24 2012

Hi,

I am trying to convert Century date for example 1121220 number(7) to a Calendar date like this 2012/12/20. I am using Oracle SQL Developer. Can anyone help me here?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 21 2013

Added on Dec 21 2012

7 comments

1,990 views