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

       

      Capture.PNG

      Thanks much

      AD