TIME_TO_SEC

Description

The function converts an input TIME or DATETIME value into the total time in seconds. If the input is of DATETIME type, the function automatically extracts the time part (HH:MM:SS).

Syntax

TIME_TO_SEC(<time>)

Parameters

Parameter	Description
<time>	Required. Supports TIME or DATETIME values. If the input is DATETIME, the function extracts the time part for calculation.

Return Value

• Returns an integer representing the total seconds of the input time value.
• If <time> is NULL, the function returns NULL.

Example

SELECT TIME_TO_SEC('16:32:18'),TIME_TO_SEC('2025-01-01 16:32:18');

+---------------------------------------+--------------------------------------------------+
| time_to_sec(cast('16:32:18' as TIME)) | time_to_sec(cast('2025-01-01 16:32:18' as TIME)) |
+---------------------------------------+--------------------------------------------------+
|                                 59538 |                                            59538 |
+---------------------------------------+--------------------------------------------------+