Convert timezones, not depending on local machine timezone

Highlighted
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??
     
Highlighted
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 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog