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

Last modified: May 31, 2023

Was this article helpful?