Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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 |
+------------------------+
