Timestamp with UTC

DrGenious — Thu, 23 Jan 2020 14:25:52 GMT

HI,

I have a column with strings like "2019-03-17 06:15:00 +0400". How can I add +0400 into the time? For example "2019-03-17 10:15:00"

Thanks a lot .

Re: Timestamp with UTC

Anonymous — Sun, 02 Feb 2020 16:38:36 GMT

This is all about timezones and it can get very confusing. But essentially, what you appear to be wanting to do is to use UTC as your timezone. There are a couple of methods that Talend provide for this, but first you need to know how your data is being stored. If it is being stored as a String, then it is relatively easy. You can use code similar to below.....

String myDate = "2019-03-17 06:15:00 +0400";

Date d = routines.TalendDate.parseDate("yyyy-MM-dd HH:mm:ss X", myDate);
System.out.println(myDate);
System.out.println(routines.TalendDate.formatDateInUTC("yyyy-MM-dd HH:mm:ss", d));

The code above outputs (to the System.out) your date as a UTC date in String form. Copy and paste this code into a tJava and you will see what I mean.

topic Timestamp with UTC in Talend Studio

Timestamp with UTC

Re: Timestamp with UTC