Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

TIME_TO_SEC(time) returns the time argument, converted to seconds

mysql> mysql> SELECT TIME_TO_SEC('22:23:00'); +-------------------------+ | TIME_TO_SEC('22:23:00') | +-------------------------+ |                   80580 | +-------------------------+ 1 row in set (0.00 sec)