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 :/
Solved! Go to Solution.
ou can use in tMap
by the way - one very good guy, make this site for help us
Java Simple Date tester online
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.
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"
Hii, Can you tell me how to convert date time utc to pst in tmap in talend without create routines
What are You mean?:
at this moment I am not sure at 100% the format of the date that I am getting.
I have a similar question. A web service is returning the date in this format:
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.
What do you make of this sample date format I'm getting from Workfront API.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs