12 Replies Latest reply: Dec 21, 2016 1:13 AM by Gysbert Wassenaar RSS

    date comparision is not happeing for delta load

    Aniruddhya Dutta

      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