MySQL TIME_TO_SEC() Function

The MySQL TIME_TO_SEC() function converts a time value into numeric seconds. A time value can range from '-838:59:59' to '838:59:59'.

Syntax

TIME_TO_SEC(time)

Parameters

Return Value

Returns the numeric seconds based on converting the specified time.

Example 1:

The example below shows the usage of TIME_TO_SEC() function.

mysql> SELECT TIME_TO_SEC('00:00:50');
Result: 50

mysql> SELECT TIME_TO_SEC('00:08:20');
Result: 500

mysql> SELECT TIME_TO_SEC('02:46:40');
Result: 10000

mysql> SELECT TIME_TO_SEC('117:37:36');
Result: 423456

mysql> SELECT TIME_TO_SEC('-117:37:36');
Result: -423456

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to get the numeric seconds value by converting the records of column Time.

SELECT *, TIME_TO_SEC(Time) AS TIME_TO_SEC_Value FROM Sample;

This will produce the result as shown below: