Convert timezones, not depending on local machine timezone

One Star

Convert timezones, not depending on local machine timezone

I have two databases.
One has plain date/time fields, without timezone specifications. But I do know it's the Dutch timezone.
(Summer = GMT +02:00, Winter = GMT +01:00)
Dutch time table            ->      UTC table
23-10-2015 16:00          ->      23-10-2015 14:00
26-10-2015 16:00          ->      23-10-2015 15:00
How can I convert date/time between these tables?
I have tried the solution in This topic but that's based on de timezone of the machine. So if I convert the data, when the timezone of the machine is in daylightsaving, the first record is converted in the correct way, but the second isn't. And in wintertime, the second record is converted the right way, but the first isn't.
What's the solution for this??
     
Moderator

Re: Convert timezones, not depending on local machine timezone

Hi,
Could you please take a look at a related forum:https://www.talendforge.org/forum/viewtopic.php?id=9322 to see if the solution is working for your use case?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download