topic Re: Change a string to Date format in Talend Studio

Change a string to Date format

sbxr — Fri, 18 Jan 2019 08:20:07 GMT

Hi ,

I have a Data which has a column Transaction date which is in string how can I change it to Date type and in the below output format.

Input format --MM/dd/yyyy hh:mm

Transaction_Date

1/2/2009 6:17 AM
1/2/2009 4:53 AM

Output:format -- dd-MM-yyyy HH:mm

Transaction_Date

2-01-2009 6:17 AM
2-01-2009 4:53 AM

Thanks

ashif2 — Fri, 18 Jan 2019 10:25:11 GMT

Hi sbxr,

Here is the expression to parse the string which you have mentioned.

TalendDate.parseDate("dd/MM/yyyy hh:mm aa",row1.Transaction_Date)

Anonymous — Fri, 18 Jan 2019 11:20:27 GMT

Thank you for answer! I had the same issue!