THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL SEC_TO_TIME() Function

❮ MySQL Functions

Example

Return a time value based on a specified seconds value:

SELECT SEC_TO_TIME(1);
Try it Yourself »

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

Parameter Description
seconds Required. The number of seconds. Both positive or negative values are allowed

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Return a time value based on a specified seconds value: 

SELECT SEC_TO_TIME(-6897);
Try it Yourself »

❮ MySQL Functions