I am running a MySQL that needs to insert a TIME type value into a table.
Currently it goes
INSERT INTO my_table (time_value) VALUES ('05:00:00')
INSERT INTO my_table (time_value) VALUES (sec_to_time(time_to_sec('05:00:00') * 0.2))
Or just do the same calculation in php and just insert the result into MySQL. See Convert time in HH:MM:SS format to seconds only? question here on SO for time to second conversion.