Loading lesson path
Concept visual
Start at both ends
Return a time value based on a specified seconds value:
SELECT SEC_TO_TIME(1);The SEC_TO_TIME() function returns a time value (in format HH:MM:SS) based on the specified seconds.
SEC_TO_TIME( seconds )
Required. The number of seconds. Both positive or negative values are allowed
From MySQL 4.0
Return a time value based on a specified seconds value:
SELECT SEC_TO_TIME(-6897);❮ MySQL Functions