How do I convert a local database which contains the data in local time format? Now I want to load this data into a central MySQL database which contains the data in UTC format. Can anyone suggest how do I convert my local time into UTC and vice-versa in Talend?
Examples:
23-10-2015 16:00 Local time => 23-10-2015 14:00 UTC (and vice versa)
26-10-2015 16:00 Local time => 26-10-2015 15:00 UTC (and vice versa)