Seven Stars

UTC TMAP format

Hi,

 

I am receiving from my webservice a datetime with UTC format

 

123.JPG

 

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

 

1234.JPG

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: UTC TMAP format

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

8 REPLIES
Twelve Stars

Re: UTC TMAP format

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 Smiley Happy
Java Simple Date tester online

 

very useful!

-----------
Seven Stars

Re: UTC TMAP format

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.

Twelve Stars

Re: UTC TMAP format

 

What are You mean?:

 


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

 

 

-----------
Seven Stars

Re: UTC TMAP format

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"

Seven Stars

Re: UTC TMAP format

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

Four Stars

Re: UTC TMAP format

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.

 

 


 

Five Stars

Re: UTC TMAP format

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:ssSmiley FrustratedSSXXX" 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.

Five Stars

Re: UTC TMAP format

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:ssSmiley FrustratedSSXXX

 

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