6 Replies Latest reply: Nov 8, 2017 6:12 AM by shair abbas RSS

    Date Parameter Issue in Qliksense Extraction

    shair abbas

      Hi guys,
          Please Help me out i am trying to extract data from Oracle DB on particular date but somehow i am unable to do this i have tried following script

       

      LIB CONNECT TO 'Snd Pro';

      CASHMEMO_DETAIL:

      SQL SELECT  *

      FROM "SNDPRO"."SCHEME_DISCOUNT_DETAIL"

      where TO_CHAR(cast(DOC_DATE),'ddMONyyyy')= '01NOV2017';

       

      this particular script is running properly on some table but get ‘0’ no of records on other tables.

      I have tried following date format but getting 0 no of rows

      DOC_DATE >= ’01-NOV-2017’

      DOC_DATE >= ‘vDate’; // in vDate we have value ’01-NOV-2017’

      DOC_DATE >= ‘01/11/2017’

      DOC_DATE >= ‘01/NOV/2017’

      DOC_DATE >= ‘11/01/2017’

      DOC_DATE >= ‘2017-11-01’