Tutorial Gateway

MySQL TIME_TO_SEC Function

by

MySQL TIME_TO_SEC function is a Date Function, which converts and return the Time argument into seconds.

In this article, we will show you, How to use this Time To Sec function to convert time to seconds in MySQL from an expression with example.

MySQL TIME_TO_SEC Syntax

The basic syntax of the Time to second Function in MySQL is as shown below:

TIME_TO_SEC(Time);

MySQL TIME_TO_SEC function Example

The following examples helps you understand the use of Time to Second function. Here, we are using different time values as an input for the function.

SELECT TIME_TO_SEC('10:22:30');

SELECT TIME_TO_SEC('01:00:00');

SELECT TIME_TO_SEC('23:59:59');

OUTPUT

MySQL TIME_TO_SEC Function 1

Let us see another example of the Time to second function. Here, we are using NOW, SYSDATE, and UTC_TIME, inside this TIME_TO_SEC function.

SELECT TIME_TO_SEC(NOW());

SELECT TIME_TO_SEC(SYSDATE());

SELECT TIME_TO_SEC(UTC_TIME);

OUTPUT

MySQL TIME_TO_SEC Function 2

Thank You for Visiting Our Blog