mysql>mysql> SELECT TIME_TO_SEC('00:39:38');+-------------------------+| TIME_TO_SEC('00:39:38') |+-------------------------+| 2378 |+-------------------------+1 row in set (0.00 sec)mysql>