Different timezone source database and Talend Server problem
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?
Could you please take a look at this topic and try the solution: Open the Run Job viewer, click on 'Advancedsettings' panel and check 'use JVM parameter' box, add the following parameter.
Could you please take a look at this topic and try the solution: Open the Run Job viewer, click on 'Advancedsettings' panel and check 'use JVM parameter' box, add the following parameter.
