Skip to Main Content

Intelligent Advisor

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!

Extract Months difference in decimal

3590037May 4 2018 — edited May 7 2018

Hello,

Can any one tell the function from which i can extract months difference between given date in decimal format ?

I tried with below but couldn't get expected solution.  For below it is giving single digit integer only.

the month difference = Round((MonthDifference(date of admission, date of inception )), 2)

the months difference = Round(the number of months from date of admission to date of inception, 2)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2018
Added on May 4 2018
3 comments
372 views