Syntax
SEC_TO_TIME(seconds)
Purpose
SEC_TO_TIME() returns the seconds argument that is converted to a time type. The range of the result is limited to that of the TIME data type.
Examples
obclient> SELECT SEC_TO_TIME(2378);
+-------------------+
| SEC_TO_TIME(2378) |
+-------------------+
| 00:39:38 |
+-------------------+
1 row in set
obclient> SELECT SEC_TO_TIME(2378) + 0;
+-----------------------+
| SEC_TO_TIME(2378) + 0 |
+-----------------------+
| 3938 |
+-----------------------+
1 row in set