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

[#1]

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.

[rbecher]

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