How to fix Execute Query issue while updating current date & time into Database

I am trying to update the current system Date & time into SQL Database, but getting below error can anyone please advice on this hot to fix this.

Below is my SQL Query.

Below is the Parameters.
image

Below is the Error.

1 Like

you have to pass the variables in values part!
like this values(+BATCHNO+ “,” +DESCRIPTION+ “,” and so on)

cheers
@nm09011985

2 Likes

Hi,
I tried this but getting another error.

1 Like

be aware of the + signs must connect the variables with the static text of your query like:
"SELECT * FROM TABLE1 WHERE NAME="+myVariableName+" AND TEST="+myVariableTest