SEC_TO_TIME
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 | +------------------------+