Discrepencies with datetime when export in csv file

[LDonini1609945263]

Hi,

I have a strange problem when I execute through TMC (cloud, working with remote engine) a simple flow with tDBinput (MySql8) as input (with a simple query) and a tFileOuputDelimited as an output.

My datetime values between my database and the CSV file are different (sometimes 1 hour, sometimes 2 hours (summer time change)). I'm in France.

Any ideas ?

Regards,

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are? Would you mind post some trouble screenshots on community which will be helpful for us to address your issue. Mask your sensitive data.

Best regards

Sabrina

[gjeremy1617088143]

Hi @Laurent Donini​ , maybe it's due to the fact that aws server location in Europe are in Dublin.

[LDonini1609945263]

Hi,

Here is my version:

Talend Cloud Data Integration

Version: 7.3.1

Build id: R2021-09

My Flow is basically like that:

In my input query (MySQL), I have this record:

And in my output file, I get that:

Regards,