Skip to main content

time_to_sec

Description​

Converts a time value into the number of seconds. The formula used for the conversion is as follows:

Hour x 3600 + Minute x 60 + Second

Syntax​

BIGINT time_to_sec(TIME time)

Parameters​

time: It must be of the TIME type.

Return value​

Returns a value of the BIGINT type. If the input is invalid, NULL is returned.

Examples​

select time_to_sec('12:13:14');
+-----------------------------+
| time_to_sec('12:13:14')     |
+-----------------------------+
|                        43994|
+-----------------------------+