topic Re: MySQL output shifting FirstOfMonth to End of Previous Month in Talend Studio

MySQL output shifting FirstOfMonth to End of Previous Month

Anonymous — Sat, 16 Nov 2024 05:18:39 GMT

Hello everyone,,

OK, this is weird... I am calculating a firstOfMonth value that shows up properly in the last tLog before inserting into MySQL:

2019-01-06

2019-01-07

2019-01-08

2019-01-09

But when I query the database, all 4 of those show up as:

2019-05-31

2019-06-30

2019-07-31

2019-08-31

What the heck?

Re: MySQL output shifting FirstOfMonth to End of Previous Month

Anonymous — Thu, 11 Jul 2019 21:57:45 GMT

Hi,

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 🙂

Re: MySQL output shifting FirstOfMonth to End of Previous Month

TRF — Thu, 11 Jul 2019 23:09:38 GMT

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".