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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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