Pass Current Date Variable to SQL

I have current an Variable with Current Date. I would like to use this variable in my SQL Executor Node to Update a Table. Can anyone assist??

KNIME_project.knwf (19.3 KB)

Hi there,

I have checked your workflow and seems ok but can’t test it obviously. Do you have any problems, errors, update doesn’t happen?

Additionally you can use new DB nodes (not legacy ones) and there is DB Update node which outputs information about success/failure of update action and number of affected rows.

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.