MySQL output shifting FirstOfMonth to End of Previous Month

Highlighted
Four Stars

MySQL output shifting FirstOfMonth to End of Previous Month

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?

 
 
Employee

Re: MySQL output shifting FirstOfMonth to End of Previous Month

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 :-)

Fifteen Stars TRF
Fifteen Stars

Re: MySQL output shifting FirstOfMonth to End of Previous Month

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


TRF

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download