TIME_TO_SEC

MySQL

TIME_TO_SEC(time)

• time: This represents the time value that would be converted into seconds. The time value must be in the format ‘HH

Example

SELECT TIME_TO_SEC('22:23:00');

Output

80280

Explanation

This SQL function converts a time value in the format of ‘HH:MM:SS’ into seconds. In this example, it converts ‘22:23:00’ into 80280 seconds.