Formatting out a column value - mm:ss.hh
You could convert to time by adding the seconds to a constant date and then subtracting it:

select timediff(cast(date_add('2001-01-01', interval t.time second)
                     as datetime(3)),
                cast('2001-01-01' as datetime(3))
               ) as ttime
from tableX as t ;


You can then format the time(3) result with the available time formatting function.