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!

Reg: TimeStampDiff(SQL_TSI_HOUR)

User_JZKI6Oct 28 2021 — edited Oct 28 2021

Hi All,
We are calculating Hours diff between the dates in report level date format (MM-DD-YYYY)
Using below formula, but 3rd and 4th records it was showing the same Hrs_diff even the end date time is different can some help like how exactly this function calculate the Hours between dates.
Hrs _Diff = TimeStampDiff(SQL_TSI_HOUR,"Job".”Start Date","Job"."End Date")
Version we are using: Oracle Business Intelligence 12.2.1.4.0
Thanks in advance,

Added on Oct 28 2021

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

1 comment

215 views