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.



      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 ?