Convert a specified number of seconds into a corresponding time value.
SELECT SEC_TO_TIME(1); |
The SEC_TO_TIME() function converts a specified number of seconds into a time value formatted as HH:MM
SEC_TO_TIME(seconds) |
Parameter |
Description |
seconds |
Mandatory: Specifies the number of seconds, allowing both positive and negative values. |
Works in: |
From MySQL version 4.0 |
Generate a time value based on a specified number of seconds.
SELECT SEC_TO_TIME(-6897); |