Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
DataEngineer1978
Contributor
Contributor

My Date format is erroring out -- it's ODBD Canonical time format -

Good Afternoon, I am having an issue with Talend converting my "Date to a string" --> that's the error I get. This date time format is called ODBD Canonical. It's an ISO 8601 standard - UTC Time. I am pretty sure I am not representing it correctly in Talend which is why the error.

This time format is represented as this:

YYYY-MM-DDTHH:MM:SS --> in Talend I have entered it as "yyyy-MM-ddTHH:MM:SSZ" --> what is the correct format representation for Talend. An example of a time I am trying to convert is this: 2019-01-16T00:00:00Z -> how do I represent this correctly so that it converts? I have already tried as a string and it doesn't work ---> so it needs to be as a "date" but it's the nomenclature of the date that's not yet converting....

Any help would be greatly appreciated.

Labels (5)
1 Reply
Anonymous
Not applicable

Hi

 

Please try this pattern

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

 

Regards

Shong