MySQL SEC_TO_TIME() Function

Return a time value based on a specified seconds value:

SELECT SEC_TO_TIME(1);

Definition and Usage

The SEC_TO_TIME() function returns a time value (in format HH:MM:SS) based on the specified seconds.

SEC_TO_TIME( seconds)

Parameter	Description
seconds	Required. The number of seconds. Both positive or negative values are allowed

Works in:	From MySQL 4.0

Return a time value based on a specified seconds value:

SELECT SEC_TO_TIME(-6897);