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!

TIMESTAMPDIFF rounding to 2 decimal places instead of 0

Satheesh KumarDec 19 2013 — edited Dec 19 2013

Hi,

Requirement is to find difference between two timestamp column,

as known one we cannot perform arithmetic operation in non number type in rpd.

Hence tried using TIMESTAMPDIFF function as below,

TimeStampDiff(SQL_TSI_MINUTE, MONITOR_TIMESTAMP, ATT_TIMESTAMP" )

OBIEE server converting this function to below SQL ,

ROUND( ( CAST(ATT_TIMESTAMP as DATE) - CAST(MONITOR_TIMESTAMP as DATE) ) * 1440 )

this returns value as ex: 12 as rounded value without any decimal places.

but we want to have two decimal places, how to fix this or any work around ?

Thanks,
Satheesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2014

Added on Dec 19 2013

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

7 comments

1,282 views