11 Replies Latest reply: Mar 28, 2012 2:16 PM by Eduardo Correa da Silva RSS

    Problem in conditional SELECT?

      Hello Everyone,

       

      I hope it's a very basic questions, but as I recently started working on Qlikview, i don't know how to write the correct syntax for this. I've connected through a big data table, but I don't want to select the whole table as it has 11 million record so wanted to know how can we give the conditional select statement statement?

       

      Oracle connection string;

      SQL SELECT *

      FROM table1

      Where Snapshot_Date> '9/28/2010';

       

      I added this where clause but I am getting an error which says :

       

      ErrorSource: Microsoft OLE DB Provider for Oracle, ErrorMsg: ORA-01843: not a valid month

       

      SQL SELECT *

      FROM Table1

      WHERE SNAPSHOT_DATE >= '09/8/2009'

       

      the snapshot date is a field in table1.

      Thanks. I will appreciate your replies.