file to seconds format

[Karuetl]

In the file i have talktime as below and want it to convert into seconds and load into table 

0:01:09

[vapukov]

Hi,

as a variant, you could use dateDiff

TalendDate.diffDate(TalendDate.parseDate("HH:mm:ss",row1.strTime),TalendDate.parseDate("HH:mm:ss","00:00:00"),"ss") 

[Anonymous]

@vapukov  yes this solution works