7 Replies Latest reply: Nov 2, 2012 11:06 AM by Mike Rewnick RSS

    SQL select by year

      hi, i have a small problem

       

      usually, the whole oracle DB is loaded in a QVD container.

      Now, data should be loaded incrementally, so the range of time to be loaded, has to be limited.

       

      DBconsum:

      LOAD *;

      SQL SELECT * FROM MYDB."consumption_s"

      WHERE year(TIME)= 2012 and month(TIME) = 5

      ;

       

      STORE DBconsum INTO $(vQVDStore)consumption_s_inc.QVD;

       

      usually, that would be no big deal, its very basic sql.

      the timestamp (TIME) has the format "41091,083333333" , which is usually readable by qlikview as "01.07.2012 02:00:00" or just "2012".

      but it doesnt seem to work with this sql load.

       

       

      any suggestions ?