SEC_TO_TIME Function

Description

The SEC_TO_TIME function returns the time including hours, minutes and seconds from specified argument. You can specify the INTEGER type in the range of 0 to 86,399; the value is returned in TIME type.

Syntax

SEC_TO_TIME(second)

Example

SELECT SEC_TO_TIME(82800);

   sec_to_time(82800)

=====================

  11:00:00 PM

 

SELECT SEC_TO_TIME('82800.3');

   sec_to_time('82800.3')

=========================

  11:00:00 PM

 

SELECT SEC_TO_TIME(86399)

   sec_to_time(86399)

=====================

  11:59:59 PM

 

SELECT SEC_TO_TIME(86400);

 

ERROR: Conversion error in time format.