Time difference in both hours and mins
I have used below code in column formula(OBIEE 10g)
TimestampDiff(SQL_TSI_Hour, TIMESTAMP'1998-07-31 23:35:00', TIMESTAMP'2000-04-01 14:24:00')
The result I am getting in hours. But I would like the output to be both hour and mins .
Is there any possibility to get the output this way. I have used the option decimal points
present in column properties but its not working.
The output is 3.00(Here 3 being hours)
The output requrired is 3.27(Here 3 bening hour and 27 being mins)
With above code I can only get hours.If I do on Minutes it is only showing minutes