Same query on Oracle timestamp field giving wrong result in Qlik Sense - Please help

[ananyaghosh]

Hi,

I have a materialized view in Oracle and I am using below SQL for my incremental load logic:

[Data]:

SELECT count(*)

FROM "EDI_E2E_USER"."ABC_E2E_TRACKING_RECORD"

where QLIK_ADD_DATE_TIME > '17-Aug-18 09:40:44.000000000 PM';

the sql in QLiksense gives me 61 rows, but when I execute it at Oracle side it gives me nothing as because '17-Aug-18 09:40:44.000000000 PM' is the maximum date time exists my View.

I am struggling with this for 2 days , Please help me how to overcome this?

[Gysbert_Wassenaar]

All that Qlik Sense does is hand over the SQL statement to the Oracle ODBC or OLEDB driver you use and that driver hands it over to the Oracle RDBMS for execution. Perhaps that driver modifies that sql statement. Or pehaps it uses different session parameters. Maybe a different timezone?

What you can try is finding out what is really executed in the RDBMS in both cases. Perhaps this document helps: https://oracle-base.com/articles/misc/sql-trace-10046-trcsess-and-tkprof

[ananyaghosh]

Hi,

How can I find the exact problem? or how can I get the log files from oracle? DO you know? what exactly I have to do now?

[Gysbert_Wassenaar]

Find an Oracle Database Administrator and ask him/her.

[balabhaskarqlik]

May be, can query like this:

select *
from TableA
where startdate >= to_timestamp('12-01-2012 21:24:00', 'dd-mm-yyyy hh24:mi:ss');

[ananyaghosh]

Hi,

It is giving me the same result as before and does not work for me.

Thanks,

Sandip