Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I am doing an incremental load from orace db through qliksense script.But the the compariosn in where caluse is not happening which I guess qlik is not able to pass the varibale value to oracle.
If I hard code in the where clause then it works
where LAST_DATE_TIME > TO_DATE('12/20/2016 2:29:57 AM','MM/DD/YYYY HH:MI:SS PM');
But If I am using the variable its not working though the variable is returning value
where LAST_DATE_TIME > TO_DATE('$(last_Updated_Date)','MM/DD/YYYY HH:MI:SS PM');
in qlik I am getting the last_Updated_Date as a format like this
Thanks much
AD
Thanks Sunny for your reply.
As of now I ddint tried your way since the way gysbert suggest did workd which I tried first . since it was urgent it didn't tried more.But I will let you know if also your way do work or not..:)
I think what you have found is true. It doesn't matter if you use AM, PM or A.M. or P.M. as long as you use one of them.
Like Sunny says, the format string for oracle's to_date function can be constructed in several ways to indicate an AM/PM kind of timestamp. There's no difference between AM and PM because you're not specifying a timestamp value, but a timestamp format. As soon as you use AM or PM then it's clear that you're specifying an AM/PM input format and not a HH24 format.