Please check the date format of your schema is correct while inserting data to DB. It could be some other format. You check the details by adding a tLogrow before and after the component.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Check that timezone is the same for MySql and the job JVM.
If not, it could be easier to change it for the job by setting the JVM "user.timezone" property with "-Duser.timezone=Europe/Paris" (or anything else).
Go to the Run tab, then Advance Settings and "Use Specific JVM arguments".
