Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Please try this pattern
"yyyy-MM-dd'T'HH:mm:ss'Z'"
Regards
Shong