cancel
Showing results for 
Search instead for 
Did you mean: 

How to Obtaing the Difference of Time stamps from universe level

Former Member
0 Kudos

HI ,

I am Using Oracle data source and working with Universe Designer tool

I am having requirement in one of My report in such a way that I have to calculate the

Run duration of a process as the data available to me is in the form of dd/mm/yyyy hh;mm;ss am/pm

Now I would like to calculate the run time in the format f hh:mm:ss

So, If any way is there for achieving the same at universe level can be helpful

as the same I have acchievec at report level by creating 5 variables

Thanks in Advance..........

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182521
Active Contributor
0 Kudos

Hello Tim,

For Oracle there is no datediff function which is available in other Databases.

Refer this to know more. https://forums.oracle.com/thread/2459688?start=0&tstart=0

Regards

Mani