MySQL Tutorial/Date Time Functions/TIME TO SEC
SELECT TIME_TO_SEC("00:39:38");
<source lang="sql">
mysql> mysql> mysql> SELECT TIME_TO_SEC("00:39:38"); +-------------------------+ | TIME_TO_SEC("00:39:38") | +-------------------------+ | 2378 | +-------------------------+ 1 row in set (0.00 sec) mysql></source>
TIME_TO_SEC(time) returns the time argument, converted to seconds.
<source lang="sql">
mysql> mysql> SELECT TIME_TO_SEC("22:23:00"); +-------------------------+ | TIME_TO_SEC("22:23:00") | +-------------------------+ | 80580 | +-------------------------+ 1 row in set (0.00 sec)</source>