To convert the interval to a TIME value, pass it to SEC_TO_TIME( ): : SEC_TO_TIME « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. SEC_TO_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>








Related examples in the same category

1.Use SEC_TO_TIME to make time more understandable
2.SEC_TO_TIME(MOD(TIME_TO_SEC(t1) + TIME_TO_SEC(t2), 86400))
3.SEC_TO_TIME( ) converts the equivalent number of seconds to a TIME value