1 Reply Latest reply: Nov 1, 2011 6:24 AM by Ralf Becher RSS

    Has anyone worked with INTERVAL DAY TO SECOND Data Type over ODBC?

    Leo Varughese

      I am currently working with an Oracle table that stores some columns as

      INTERVAL DAY TO SECOND Data Type

       

      as I am retrieving the data over ODBC I get a "ODBC read error".

      if I remove this field and get all other fields it works fine.

       

      Has anyone out here used such a data type on oracle table and fetched it to QlikView?

      what options are available?

       

      regards

      Leo V.

        • Has anyone worked with INTERVAL DAY TO SECOND Data Type over ODBC?
          Ralf Becher

          Hi Leo,

           

          you can use a date operation (+/-) to convert this interval type to a number:

           

          SELECT (duration + trunc(sysdate) - trunc(sysdate)) as n_duration FROM ...

           

          or you can extract pieces and combine them:

           

          SELECT EXTRACT(DAY FROM duration) ||

                ' days, ' || EXTRACT (HOUR FROM duration) ||

                ' hours, ' || EXTRACT (MINUTE FROM duration) ||

                ' minutes' as c_duration

          FROM ...

           

          It depends what you want to do with the interval value.

           

          - Ralf