UTC TMAP format

[Anonymous]

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!

[vapukov]

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!

[Anonymous]

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.

[vapukov]

What are You mean?:

---

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

[Anonymous]

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"

[Anonymous · Accepted solution]

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

[Sunny_Nanda]

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.

---

[Anonymous]

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.

[Anonymous]

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.