Product Solutions Support
Try MemSQL

SEC_TO_TIME

Return a time object corresponding to the input second count.

SEC_TO_TIME ( sec )

Arguments

Return Type

A time object.

Examples

memsql> select sec_to_time(84690);
+--------------------+
| sec_to_time(84690) |
+--------------------+
| 23:31:30           |
+--------------------+

memsql> select sec_to_time(-10000000);
+------------------------+
| sec_to_time(-10000000) |
+------------------------+
| -838:59:59             |
+------------------------+
Was this article useful?