Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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>