bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL SEC_TO_TIME() Function

Example

SELECT SEC_TO_TIME(1);

Definition and Usage

The SEC_TO_TIME() function returns a time value (in format HH:MM:SS) based on the specified seconds.

Syntax

SEC_TO_TIME(
seconds
)

Parameter Values

ParameterDescription
secondsRequired. The number of seconds. Both positive or negative values are allowed

Technical Details

Works in:From MySQL 4.0

Previous

MySQL SECOND() Function

Next

MySQL STR_TO_DATE() Function