https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259787#M41149 <P>Hi,</P><P>&nbsp;</P><P>as a variant, you could use dateDiff</P><P>&nbsp;</P><PRE>TalendDate.diffDate(TalendDate.parseDate("HH:mm:ss",row1.strTime),TalendDate.parseDate("HH:mm:ss","00:00:00"),"ss") </PRE> Tue, 12 Feb 2019 21:27:08 GMT vapukov 2019-02-12T21:27:08Z https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259786#M41148 <P>In the file i have talktime as below and want it to convert into seconds and load into table&nbsp;</P><P>0:01:09</P> Tue, 12 Feb 2019 20:19:38 GMT https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259786#M41148 Karuetl 2019-02-12T20:19:38Z https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259787#M41149 <P>Hi,</P><P>&nbsp;</P><P>as a variant, you could use dateDiff</P><P>&nbsp;</P><PRE>TalendDate.diffDate(TalendDate.parseDate("HH:mm:ss",row1.strTime),TalendDate.parseDate("HH:mm:ss","00:00:00"),"ss") </PRE> Tue, 12 Feb 2019 21:27:08 GMT https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259787#M41149 vapukov 2019-02-12T21:27:08Z https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259788#M41150 <P><A href="https://community.qlik.com/s/profile/005390000067LRbAAM">@vapukov</A>&nbsp; yes this solution works</P> Wed, 13 Feb 2019 21:39:46 GMT https://community.qlik.com/t5/Talend-Studio/file-to-seconds-format/m-p/2259788#M41150 Anonymous 2019-02-13T21:39:46Z