I'm using TOS to migrate data From MySQL db to an Oracle db, in one of my tables i need to my table i have to transform the Date fotmat to insert the date in the oracle database here is the originat and the target format :
MySQL db ------------->>>>>> Oracle db
Type "String" Type "Date"
Format " dd-MM-yy " ------->>>> Format " yyyy-MM-dd "
i tried the TalendDate.parseDate("dd-MM-yy",row1.DateMesD) function but it seems that it dooesn't work !!!!
Thanks in advance for your responses.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend