Oracle Interval data type
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.