TO_SECONDS

Description

Seconds calculation function. It converts a date to a seconds value, calculating the total seconds from the base date (0000-00-00) to the specified date.

This function behaves consistently with the to_seconds function in MySQL.

Syntax

TO_SECONDS(`<date_or_time_expr>`)

Parameters

Parameter	Description
<date_or_time_expr>	The input date/time value. Supports date/datetime types. For specific datetime and date formats, please refer to datetime conversion and date conversion.

Return Value

Returns the total number of seconds from the zero date (0000-00-00) to the specified date and time, of type BIGINT.

If the input is NULL, then NULL is returned.

Examples

-- Based on the date `0000-00-00`
select to_seconds('0000-01-01');
+--------------------------+
| to_seconds('0000-01-01') |
+--------------------------+
|                    86400 |
+--------------------------+
-- Starting from 00-00, count 1 day, a total of 24 * 3600 == 86400 seconds.

select to_seconds('2025-01-01'), to_seconds(20250101);
+--------------------------+----------------------+
| to_seconds('2025-01-01') | to_seconds(20250101) |
+--------------------------+----------------------+
|              63902908800 |          63902908800 |
+--------------------------+----------------------+

SELECT
    to_seconds('2025-01-01 11:22:33') AS datetime_type,
    to_seconds(20250101112233) AS int_type;
+---------------+-------------+
| datetime_type | int_type    |
+---------------+-------------+
|   63902949753 | 63902949753 |
+---------------+-------------+

select to_seconds('9999-12-31 23:59:59.999999');
+------------------------------------------+
| to_seconds('9999-12-31 23:59:59.999999') |
+------------------------------------------+
|                             315569519999 |
+------------------------------------------+

SELECT to_seconds(NULL);
+------------------+
| to_seconds(NULL) |
+------------------+
|             NULL |
+------------------+