https://community.qlik.com/t5/Talend-Studio/Converting-seconds-to-hours-and-minutes-using-Tmap/m-p/2255595#M38252 Since this is not a standart date storage (not like a real timestamp) you'll have to do your own java function in order to do so... Tue, 01 Feb 2011 17:13:40 GMT Anonymous 2011-02-01T17:13:40Z https://community.qlik.com/t5/Talend-Studio/Converting-seconds-to-hours-and-minutes-using-Tmap/m-p/2255594#M38251 Hi All, <BR />I have a flow containing a database query that extracts a "time" and places the output into an excel spreadsheet. My obstacle is that the "time" that is extracted is presented in number of seconds after midnight. I would normally convert this from the beginning in the database query but I am stuck with using what appears to be a rather limited ODBC driver. <BR />I am hoping to use Tmap so as to convert an integer value to a time which will sit nicely in my excel spreadsheet (the final destination/output). <BR />Example: <BR />53201 needs to be converted/displayed as 14:46:21 <BR />Any assistance would be greatly appreciated! <BR />Thanks, <BR />Jon Sat, 16 Nov 2024 13:06:55 GMT https://community.qlik.com/t5/Talend-Studio/Converting-seconds-to-hours-and-minutes-using-Tmap/m-p/2255594#M38251 _AnonymousUser 2024-11-16T13:06:55Z https://community.qlik.com/t5/Talend-Studio/Converting-seconds-to-hours-and-minutes-using-Tmap/m-p/2255595#M38252 Since this is not a standart date storage (not like a real timestamp) you'll have to do your own java function in order to do so... Tue, 01 Feb 2011 17:13:40 GMT https://community.qlik.com/t5/Talend-Studio/Converting-seconds-to-hours-and-minutes-using-Tmap/m-p/2255595#M38252 Anonymous 2011-02-01T17:13:40Z