on 10-28-2015 7:17 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.