compare two date and load results in database

[Anonymous]

hello , 

I am beginner in talend and i need help 

i have building a job wich load results in database with result of comparaison of two date

in my first component tparam , we have the result of the last update date and in the W-CLIENT 

we have the update date of any enregistrement in the database 

we should have the the enregistrement in the database which the update date >= Tparam date 

incremental loading 

there is a screenshot which describe the job 

[Anonymous]

It looks like you are trying to prepare a SQL query which is used to return data based on a date comparison. If that is the case, you need to think about the following. Dates are not necessarily converted and formatted as Strings in the correct format for a SQL query. So you will need to use the routines.TalendDate methods to format your date in the correct format to be used in your query. The next thing to think about is that you will need to test this query. The best thing to do here is to test your query using a query analyser tool. I see you are printing your Query to the output, so I assume this is what you are trying.