The SEC_TO_TIME function returns the time including hours, minutes and seconds from specified argument. You can specify the INTEGER type in the range of 0 to 86,399; the value is returned in TIME type.
SEC_TO_TIME(second)
SELECT SEC_TO_TIME(82800);
sec_to_time(82800)
=====================
11:00:00 PM
SELECT SEC_TO_TIME('82800.3');
sec_to_time('82800.3')
=========================
11:00:00 PM
SELECT SEC_TO_TIME(86399)
sec_to_time(86399)
=====================
11:59:59 PM
SELECT SEC_TO_TIME(86400);
ERROR: Conversion error in time format.