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

Tue, 01 Nov 2011 09:06:37 GMT

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

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 — Tue, 01 Nov 2011 10:24:20 GMT

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

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