1 Reply Latest reply: Nov 6, 2012 9:54 AM by Erich Shiino RSS

    Time format error

    Kinjal Shah

      I am trying incremental load and am getting this error while reload. Any suggestion on what is the right format

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1:41:04 PM' at line 20

        • Re: Time format error
          Erich Shiino

          Hi,

          Can you share your script?

          I believe that the date that you use to get new data was not recognized by the database

           

          Or you can also check your log ( it can be enable on settings-> document properties -> general tab -> generate log file). After a reload a file with the extension .log will be created on the same folder of your qvw.

          There you can check the parameters that were sent in your query

           

          Regards,

          Erich