H@wk wrote:

Hello,
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.