Mega Code Archive

 

Categories / MySQL / Date Time

 

To convert the interval to a TIME value, pass it to SEC_TO_TIME( )

mysql> mysql> SELECT SEC_TO_TIME(@interval) AS TIME; +-----------+ | TIME      | +-----------+ | 168:00:00 | +-----------+ 1 row in set (0.00 sec) mysql>