One Star

Converting seconds to hours and minutes using Tmap?

Hi All,
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.
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).
Example:
53201 needs to be converted/displayed as 14:46:21
Any assistance would be greatly appreciated!
Thanks,
Jon
1 REPLY
Employee

Re: Converting seconds to hours and minutes using Tmap?

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