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 Serial Number into Date

470436Aug 2 2007 — edited Aug 2 2007

Hi,

I have data stored as Number which infact is a date

For Ex 39090 is actually 01-Aug-2007

i need to convert this Number into date format like described above

the function To_date requires the data to be a varchar2

Can anyone help me in solving this

With Warm Regards
SSR

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2007

Added on Aug 2 2007

18 comments

6,486 views