MySQL SEC_TO_TIME function is one of the Date Function, which is used to convert the user given seconds into Time value. This function returns output Time in Hours:Minutes:Seconds format.
In this article, we will show you, How to use this MySQL SEC_TO_TIME function to convert total number of seconds into Time with an example.
MySQL SEC_TO_TIME Syntax
The basic syntax of the SEC_TO_TIME() Function in MySQL is as shown below:
SEC_TO_TIME(Seconds);
MySQL SEC_TO_TIME function Example
The below shown queries helps you understand the use of this MySQL Second to Time function. Here, we are converting different seconds value to Time.
SELECT SEC_TO_TIME(5);
SELECT SEC_TO_TIME(67);
SELECT SEC_TO_TIME(3717);
OUTPUT
In this example, we are converting seconds to time. Next, we are adding few seconds to that output. It means, they will return the output as HHMMSS format.
SELECT SEC_TO_TIME(7334);
SELECT SEC_TO_TIME(7334), SEC_TO_TIME(7334) + 0;
SELECT SEC_TO_TIME(10334), SEC_TO_TIME(10334) + 22;
OUTPUT
Thank You for Visiting Our Blog
