Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time format error

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

1 Reply
erichshiino
Partner - Master
Partner - Master

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