Syntax
SEC_TO_TIME(seconds)
Purpose
You can call this function to return the seconds argument that is converted to a time type. The range of 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 (0.00 sec)
obclient> SELECT SEC_TO_TIME(2378) + 0;
+-----------------------+
SEC_TO_TIME(2378) + 0
+-----------------------+
3938
+-----------------------+
1 row in set (0.00 sec)