MySQL TIME_TO_SEC() Function

Convert a time value into seconds: SELECT TIME_TO_SEC("19:30:10");

The TIME_TO_SEC() function converts a time value into seconds.

TIME_TO_SEC( time )

Required. The time value

From MySQL 4.0

Convert a time value into seconds: SELECT TIME_TO_SEC("00:00:05");

Convert a time value into seconds: SELECT TIME_TO_SEC("03:30:00.999999");

Convert a time value into seconds: SELECT TIME_TO_SEC("-03:30:00");

❮ MySQL Functions