Datetime parsing

[Anonymous]

Hi 

I am getting errors when I am trying to map a string field containing datetime data(from csv) from source to the final table using tmap.

I attach the screen shots below of the same.

I am using talend.dateparse function for getting the desired result but its showing unparseable date. The time stamp is not getting parsed and is throwing runtime error.   

Please help resolve this issue.

[Anonymous · Accepted solution]

Hi
I just made a testing: read the sample file using tFileInputDelimited, convert the string to a Date using expression
TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row2.Swipe_In_Time)
tFileInputDelimited--main--tMap--tLogRow

The job runs fine.

Regards
Shong