Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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