Analytics Software

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!

difference between two dates in year/Month/Days in Obiee

user13483708Feb 2 2015 — edited Feb 3 2015

Hi Gurus,

I know this question have been asked and answered many times but I have a requirement which is a bit different then the previous ones.

I want to calculate the difference between two dates in OBIEE10g in Year/Months/Days format similar to the output of below SQL

SQL> select end_date, start_date ,

trunc( months_between( end_date, start_date ) /12 ) Years,

mod( trunc( months_between( end_date, start_date ) ), 12 ) months,

end_date - add_months(start_date,trunc( months_between(end_date,start_date) )) days

from t

Thanks in Advance

This post has been answered by SriniVEERAVALLI on Feb 2 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2015

Added on Feb 2 2015

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

7 comments

3,935 views