[resolved] how to convert datetime from xml to timestamp ?

[Anonymous]

Hi,
Since the Talend does not have the timestamp mapping type. It maps the timestamp to date type. But this is not good to process a XML datetime of """yyyy-MM-ddThh:mm:ss" (a "T" inside). The run time error is below error even if I defined the parsing format "yyyy-MM-ddThh:mm:ss"
Exception in component tXMLMap_1_TXMLMAP_OUT
java.lang.RuntimeException: Unparseable date: "2013-06-28T20:01:30"
The "T" is a standard datetime in XML and we have to accept it (data from the customer).
Is there any way to solve this ?
Thanks !
James

[Anonymous · Accepted solution]

Hi James
Thanks for your detailed information, I think I have found out the issue, you need to open the Tree schema editor, and change the data type of the date column to Date and set its date pattern. Please see my screenshot.
Shong

[Anonymous]

It worked. Thanks a lot !
But I have further questions for that schema. I will write the details in email.
Thanks !
James

[_AnonymousUser]

Hi James
Thanks for your detailed information, I think I have found out the issue, you need to open the Tree schema editor, and change the data type of the date column to Date and set its date pattern. Please see my screenshot.
Shong

Hi Shong / James,
I did changes as mentioned in the screen shot, but still its not working for me.
Can you help me out.
Thanks,
Kyasanur

[Anonymous]

Hi,

Tried changing the pattern in the tree schema, still it did not work. Kindly help.

Thanks!