topic Re: UTC TMAP format in Talend Studio

UTC TMAP format

Anonymous — Sat, 16 Nov 2024 09:34:07 GMT

Hi,

I am receiving from my webservice a datetime with UTC format

How should I configure TMAP field to get this date format? Probably with a "Z" at the end but I am getting errors 😕

Thanks!

Re: UTC TMAP format

vapukov — Mon, 03 Jul 2017 10:08:03 GMT

ou can use in tMap

yyyy-MM-dd'T'HH:mm:ss Z

by the way - one very good guy, make this site for help us
Java Simple Date tester online

very useful!

Re: UTC TMAP format

Anonymous — Tue, 04 Jul 2017 14:13:07 GMT

Hi,

I was wrong with the input values, at this moment I am not sure at 100% the format of the date that I am getting.

My client says that the format is datetime with those specifications: https://www.w3.org/TR/xmlschema-2/#dateTime

I don't really know what I should put on TMAP, I have tried a lot of formats. The datetime format should be the UTC.

Re: UTC TMAP format

vapukov — Tue, 04 Jul 2017 14:22:22 GMT

What are You mean?:

at this moment I am not sure at 100% the format of the date that I am getting.

Re: UTC TMAP format

Anonymous — Tue, 04 Jul 2017 15:10:58 GMT

My client is sending me a datetime through a webservice, he says that the format is represented using this reference: https://www.w3.org/TR/xmlschema-2/#dateTime

I have no idea of how to get his date, I am getting errors all the time. I think that I am supposted to get something like 2017-06-25 12:10:13+02:00

I tried "yyyy-MM-dd HH:mm:ss Z"

Re: UTC TMAP format

Anonymous — Tue, 04 Jul 2017 15:54:52 GMT

I have resolved the problem. Correct date pattern was: "yyyy-MM-dd'T'HH:mm:ssXXX"

Re: UTC TMAP format

Sunny_Nanda — Thu, 30 Nov 2017 06:07:21 GMT

Hii, Can you tell me how to convert date time utc to pst in tmap in talend without create routines

@vapukov wrote:

What are You mean?:

at this moment I am not sure at 100% the format of the date that I am getting.

Re: UTC TMAP format

Anonymous — Sat, 14 Apr 2018 00:01:56 GMT

I have a similar question. A web service is returning the date in this format:

2018-01-18T18:22:52:877-0500

The expected mask is: "yyyy-MM-dd'T'HH:mm:ssSSXXX" but this is failing when used with TalendDate.isDate() and To_Date. What am I missing here?

Note: I do think the colon between the seconds and fractional seconds should really be a period, but they're sending a colon there. Hacking the input to a period still fails. The Format Tester site produced correct outputs for this mask, but the parser fails.

Re: UTC TMAP format

Anonymous — Sat, 14 Apr 2018 00:09:04 GMT

What do you make of this sample date format I'm getting from Workfront API.

2018-01-18T18:57:22:123-0500

The mask I tried was: yyyy-MM-dd'T'HH:mm:ssSSXXX

I do suspect the colon between the ssSS should probably be a period, but this is what they're sending.