topic Re: Time difference issue in Talend in Talend Studio

Time difference issue in Talend

WWong1683187644 — Fri, 15 Nov 2024 21:38:27 GMT

Hi,

I am using talend to extract data from database, then export to csv.

But i notice the time value output to csv is wrong, it is not the original time value in database.

I suspect could be due to database server and talent server's time zone is different, so causing this problem, am i right?

May i know how can i get the original time value instead of the converted time?

Re: Time difference issue in Talend

Anonymous — Tue, 27 Jun 2023 08:06:14 GMT

Hello,

Please try to do an experiment first.

Database usually can convert Date to String. Use a format that exposes the TIME ZONE as well.

Talend tLogRow can also respect such date patterns.

I have written an article about this you can find it here: https://community.talend.com/s/article/Talend-Data-Types-explained

Re: Time difference issue in Talend

Anonymous — Tue, 27 Jun 2023 08:20:06 GMT

Check the time zone of Database server, then add this line of Java code on a tJava component in the beginning of job to change the default timezone.

for example:

java.util.TimeZone.setDefault(java.util.TimeZone.getTimeZone("America/Los_Angeles"));

Regards

Shong

Re: Time difference issue in Talend

Samuel_Bennett — Tue, 27 Jun 2023 09:24:38 GMT

Check the time zone settings: Verify the time zone settings of both the database server and the Talend server. Ensure that they are configured correctly and set to the same time zone or adjust them accordingly to align with your desired output.
Adjust the time zone in Talend: In your Talend job, you can explicitly specify the time zone to be used for extracting the data from the database. You can do this by setting the time zone context variable or using a specific component or function in Talend that allows you to manipulate time zones. This way, you can ensure that the data is extracted in the desired time zone. UPSers
Convert the time zone in Talend: If you want the time values to be converted to a specific time zone during the extraction process, you can use Talend's built-in functions or components to perform the necessary time zone conversion. This will ensure that the time values in the CSV file reflect the desired time zone.

Re: Time difference issue in Talend

anselmopeixoto — Tue, 27 Jun 2023 13:17:20 GMT

Hi,

Just trying to help with another suggestion that I found useful in some situations, you could set JVM argument or system property user.timezone to match database timezone:

JVM argument examples (you can set it in Run/Advaced settings/JVM Setting):

-Duser.timezone=UTC

-Duser.timezone=America/Sao_Paulo

System property (you can use a tJava for this option):

System.setProperty("user.timezone", "UTC");

Re: Time difference issue in Talend

WWong1683187644 — Wed, 28 Jun 2023 01:14:42 GMT

looks like i don't have permission to visit the article you shared or the link broken.. 😂

Re: Time difference issue in Talend

Anonymous — Wed, 28 Jun 2023 07:17:42 GMT

I reached out to the respective team to publish it.