topic Re: Different timezone source database and Talend Server problem in Talend Studio

Different timezone source database and Talend Server problem

mauerwegrunner — Fri, 15 Nov 2024 22:15:17 GMT

I am not sure, if the Design and Development section is the right one for this topic...

I am using TOS DI 7.3, beginning with next year (2023) I will change to Talend DI on premise.

The database hosting server is running on timezone UTC. The server where the Studio is running is GMT+1 (Berlin). It is simple connection to the MySQL database.

The entry in a datetime field in MySQL is: 2025-04-30 23:59:59

After extracting it in TOS and displaying it in a tLog Component it shows: 2025-05-01 01:59:59

The two hours shift is because of summer time, in winter it is 1 hour.

The question: How it is possible to ignore the server's timezone and to load the exact value into the target database (in this cas a postgreSQL), so there is as well the 2025-04-30 23:59:59 value. I know it is possible with some field function but I have many datetime fields. Is there any entry in the jobs advance settings possible?

Thanks in advance, Matthias

Re: Different timezone source database and Talend Server problem

Anonymous — Tue, 17 Jan 2023 05:11:38 GMT

Hello,

Could you please take a look at this topic and try the solution: Open the Run Job viewer, click on 'Advanced settings' panel and check 'use JVM parameter' box, add the following parameter.

-Duser.timezone=UTC

Feel free to let us know if it works.

Best regards

Sabrina

Re: Different timezone source database and Talend Server problem

mauerwegrunner — Fri, 20 Jan 2023 11:28:40 GMT

Hello Sabrina,

it works, thanks a lot,

Matthias

Re: Different timezone source database and Talend Server problem

Anonymous — Sat, 28 Jan 2023 03:02:47 GMT

Hello,

Great it works. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina