Change a string to Date format

[sbxr]

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]

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 · Accepted solution]

Thank you for answer! I had the same issue!

My best wishes: https://diceus.com/offshore-software-development-benefits/