Formatting out a column value - mm:ss.hh I have a time in seconds and I want to convert it to the following formats possibilities:

121.17 -&gt; 2:01.17 |
34.28 -&gt; 34.28 |
133.56 -&gt; 2:13.56


I am using the following:

IF(Time &gt; 60, CONCAT(FLOOR(Time/60), ":", Time - (FLOOR(Time/60)*60)),
   Time) as TTime,

Results:
2:1.17 (incorrect) | 
34.28 (correct) | 
2:13.56 (correct)


I tried a number of things (LPAD, CONVERT, etc) 

Please advise. MySQL 5.6.17
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.