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!

Kindly suggest how to convert number into days,months,years

Afzal MogalSep 29 2013 — edited Sep 30 2013

Dear All,

I have a requirement, where I get a value from function, say 61  (in days).

I want to show in the report it as,  (60/30 + 1 )

Years  Months  Days

   0          2            1    

Kindly suggest.

Thanks in advance.

Regards,

Afzal.
This post has been answered by Etbin on Sep 29 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2013
Added on Sep 29 2013
10 comments
1,241 views