TIME_TO_SEC ? SEC_TO_TIME

Question

Im using mySQL

i have a calculation which return the value of totalUTinMinutes column in minutes and i want it to convert back into hours, column "T" but i got that result instead of 08:09:[some secs here].

any suggestion or solution. Thank you so much.

Answer 1

select sec_to_time(489.73*60);

output

08:09:43.80