TO_UNIXTIME

​

Syntax

​

To unixtime timestamp (scalar)

to_unixtime(value)

• TO_UNIXTIME accepts exactly one TIMESTAMP operand. It does not support an omitted argument or STRING parsing.

​

Arguments

​

Returns

• Type: BIGINT
• NULL behavior: Returns NULL for a NULL timestamp.

​

Properties

​

Units

• Input unit: Timestamp
• Output unit: Signed seconds since Unix epoch UTC
• Microseconds / 1000000, truncating toward zero.

​

Usage notes

• Fractional seconds are truncated toward zero, including negative epoch values.
• Pass one TIMESTAMP argument. To parse formatted text, use TO_UNIX_TIMESTAMP.

​

Examples

​

Alias calling form: TO_UNIXTIME

SELECT to_unixtime(TIMESTAMP '2024-01-01 00:00:00') AS result;

​

Unix epoch and one second later

SELECT to_unixtime(TIMESTAMP '1970-01-01 00:00:00') AS epoch, to_unixtime(TIMESTAMP '1970-01-01 00:00:01') AS one_second;

​

Limitations

• TO_UNIXTIME accepts a TIMESTAMP. The STRING-with-format, DATE, unformatted STRING, and no-argument forms are not available through this alias.

​

Related functions

• from_unixtime