topic Re: Discrepencies with datetime when export in csv file in Talend Studio

Discrepencies with datetime when export in csv file

LDonini1609945263 — Fri, 15 Nov 2024 23:02:02 GMT

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,

Re: Discrepencies with datetime when export in csv file

Anonymous — Mon, 11 Apr 2022 08:25:16 GMT

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

Re: Discrepencies with datetime when export in csv file

gjeremy1617088143 — Mon, 11 Apr 2022 09:33:45 GMT

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

Re: Discrepencies with datetime when export in csv file

LDonini1609945263 — Mon, 11 Apr 2022 13:52:12 GMT

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,