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 calculation in Teradata & Oracle

PritiApr 19 2011

Hi All,

I'm using OBIEE 10.1.3.4 version.
I have noticed difference in the calculation of TIMESTAMPDIFF (SQL_TSI_WEEK) when connecting to Teradata & Oracle as Warehouse DB.
The diff is in the way the rounding is done.
Has anyone seen similar behaviour, if yes then is it known issue & is there any solution to it?

Regards,
Priti

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2011

Added on Apr 19 2011

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

0 comments

286 views