Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
SEC_ TO_ TIME
On this page
The SEC_ function returns 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: