Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 03, 2015 at 10:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded