topic Re: Convert a String to a Date in Talend Studio

Convert a String to a Date

Anonymous — Tue, 25 Jul 2017 17:32:18 GMT

In my Tmap I am trying to map a String value over to a date. My data coming in looks like 2016-09-01T10:53:24. I need to remove the T and keep all other date time info there.

I tried to just so a row1.DateTimeModified.replace("T"," ") but that didn't work.

Re: Convert a String to a Date

vboppudi — Tue, 25 Jul 2017 18:11:35 GMT

Please try below.

Regards,

Re: Convert a String to a Date

ThWabi — Wed, 26 Jul 2017 09:25:37 GMT

Hi shawnm,

convert your modified String to a Date using

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss", row1.DateTimeModified.replace("T", " "))

Best regards,

Thomas