SEC_TO_TIME() function :
This function in MySQL is used to return a time value based on the specified seconds value. Here the returned time value will be in the format of HH:MM:SS. For example, if the specified second value is 63, this function will return “00:01:03”.
Syntax :
SEC_TO_TIME(seconds)
Parameter :
This method accepts a parameter as given below :
- seconds – Specified seconds value. This value can be both positive or negative.
Returns :
It returns a time value based on the specified seconds value.
Example-1 :
Getting the time value of “00:00:40” from the specified parameter of 40 seconds value.
SELECT SEC_TO_TIME(40);
Output :
00:00:40
Example-2 :
Getting the time value of “00:01:10” from the specified parameter of 70 seconds value.
SELECT SEC_TO_TIME(70);
Output :
00:01:10
Example-3 :
Getting the time value of “01:00:04” from the specified parameter of 3604 seconds value.
SELECT SEC_TO_TIME(3604);
Output :
01:00:04
Application :
This function is used to return a time value based on the specified seconds value.