Discussion Board for collaboration on QlikView Scripting.
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?
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
It depends what you want to do with the interval value.