Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
erich_shiino
Honored Contributor

Re: Time format error

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

Community Browser