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