I am using the source data as MySQL database and comparing the dates in the table with system generated dates in Pentaho.
I am using query like below :
Select * FROM trvs_consumer WHERE created_at > ?
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 '?' at line 25
You have to use correct date format to use in mysql query since mysql require it.
Use select values step, and specify correct date format. Here is the example. In 'get system date' step we generate new random date. In 'Select values' step we assign correct date format for mysql. Then we can use this new field in some queries. PDI does not automatically recognize correct date format for db vendor, we have to took care of that manually.