Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you for answer! I had the same issue!
My best wishes: https://diceus.com/offshore-software-development-benefits/
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)
Thank you for answer! I had the same issue!
My best wishes: https://diceus.com/offshore-software-development-benefits/