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