UTC TMAP format

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!


Accepted Solutions
Seven Stars

Re: UTC TMAP format

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


All Replies
Forteen 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.

Forteen 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.

 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read