SQL syntax

[Palaniyappan (Forum Leader)]

Hi

This means that there is a problem with the way that the date is being used in the SQL statement.

To fix this error, you need to check the SQL statement and make sure that the date is being used correctly. The date should be enclosed in single quotes (')

Like

SELECT * FROM table WHERE date = ‘2023-09-12’

Refer this thread for some insights if u r using variable

Update sql table with date format include

Dear members, I have a sql table, which include date type, need to update date from excel to the sql table, not sure which type I could set for the Parameters? I can only get datetime type variable, not sure how to get date type variable. Thanks.

Cheers @omar_ismail