topic Re: Convert String to Date in Talend Studio

Convert String to Date

Fatouil — Thu, 10 Jan 2019 09:44:02 GMT

Hello,

I have a Date "Fri, 28 Dec 2018 12:19:26 +0100" as a String.

I want to convert this string "Fri, 28 Dec 2018 12:19:26 +0100" to Date (dd-MM-yyyy)

Thanks a lot for your help.

Re: Convert String to Date

Anonymous — Thu, 10 Jan 2019 13:33:19 GMT

hello,

TalendDate.parseDate("dd MM yyyy",row1.Date_of_birth)

Re: Convert String to Date

ThWabi — Tue, 15 Jan 2019 15:23:05 GMT

Hello Fatouil,

use TalendDate.parseDate("EEE, dd MMM yyyy HH:mm:ss Z", row1.yourString) to convert your String to a Date; you can then use TalendDate.formatDate("dd-MM-yyyy", yourDate) to output the Date in the desired format.

Best regards,

Thomas