Anyone worked with INTERVAL DAY(9) TO SECOND(6) Data Type over Oracle connection in Qliksense

Anusha1430 — Thu, 24 Nov 2022 04:47:13 GMT

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

as I am retrieving the data over using Oracle connection I get a error message like below

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 Qliksense?

what options are available?

Regards,

Anusha

topic Anyone worked with INTERVAL DAY(9) TO SECOND(6) Data Type over Oracle connection in Qliksense in Connectivity & Data Prep