SEC_
On this page
Return a time object corresponding to the input second count.
Syntax
SEC_TO_TIME ( sec )Arguments
-
sec: an integer counting the seconds since midnight.
Return Type
A time object.
Examples
SELECT SEC_TO_TIME(84690);
+--------------------+
| SEC_TO_TIME(84690) |
+--------------------+
| 23:31:30 |
+--------------------+SELECT SEC_TO_TIME(-10000000);
+------------------------+
| SEC_TO_TIME(-10000000) |
+------------------------+
| -838:59:59 |
+------------------------+Last modified: May 31, 2023