Converting local time format into UTC format and vice versa using Talend

Question

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)

Answer 1

This job is pretty simple. In order to perform the conversion of local time into UTC you need to do is to add tFixedFlowInput, tJavaRow and tLogRow components into the workspace and connect them using the Row(Main) link.

Once you are done, follow the below steps:

1. Go to the component tab of the tFixedFlowInput component and specify the schema as shown below:    

2. Once done, select the Inline table option and provide the data as per requirement:

3. Now, in the component tab of tJava component, go to the advanced settings and import the given packages:  
   import java.text.SimpleDateFormat;  import java.util.Date; import java.util.TimeZone;  import java.text.ParseException;

4. Now, go to the basic settings of the tab and add the following code: 
    

   String BASE_FORMAT = "dd-MM-yyyy HH:mm"; 
   
   TimeZone utc = TimeZone.getTimeZone("UTC"); 
   
   TimeZone local = TimeZone.getTimeZone("Europe/Amsterdam"); 
   
   SimpleDateFormat formatUTC = new SimpleDateFormat( BASE_FORMAT ); 
   
   formatUTC.setTimeZone(utc); 
   
   SimpleDateFormat formatCE = new SimpleDateFormat( BASE_FORMAT ); 
   
   formatCE.setTimeZone(local); 
   
   row2.localDateTime = row1.localDateTime;

5. In the component tab of tLogRow, select the highlighted option in order to print in the key-value pair.

6. Now execute the job. You will get the required output:

Hope this will help!

Join the Talend course today to know more about and become expert.

Thanks.