cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Interval data type

Former Member
0 Kudos

How do you use Oracle Interval data types in IDT?  Is it possible?  Would I alter the oracle.prm file for IDT to support Oracle interval data type functions?  I'm in the process of converting a solution from a different BI product that allows interval data types and associated Oracle functions.  The solution requires that elapsed time in minutes be displayed HH:MM:SS.  For example if the process took 90 minutes the value would be displayed as 00 01:30.

Thanks in advance for your help.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Angela,

Could you please share some examples of interval data types?

Also if you need to convert 90 seconds to 00:01:30 hours, you can try doing it using formulas.

Regards,

Yuvraj