TO_UNIX_TIMESTAMP

​

Syntax

​

Timestamp (scalar)

to_unix_timestamp(value)

​

Parsed (scalar)

to_unix_timestamp(value, format)

​

Unix timestamp timestamp (scalar)

unix_timestamp(value)

​

Unix timestamp parsed (scalar)

unix_timestamp(value, format)

​

To unixtime timestamp (scalar)

to_unixtime(value)

• TO_UNIXTIME accepts exactly one TIMESTAMP operand. No no-argument/string parsing form.

​

Arguments

​

Timestamp, unix timestamp timestamp, to unixtime timestamp

​

Parsed, unix timestamp parsed

​

Returns

• Type: BIGINT
• NULL behavior: NULL timestamp, value or format yields NULL. Invalid string/timezone conversion raises an error.

​

To unixtime timestamp

• Type: BIGINT
• NULL behavior: NULL timestamp, value or format yields NULL. Invalid string/timezone conversion raises an error.

​

Properties

​

Units

• Input unit: Timestamp or formatted text
• 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 a TIMESTAMP, or pass a STRING together with its format. An unformatted STRING is not part of these calling forms.

​

Examples

​

Basic example

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

​

Alias calling form: UNIX_TIMESTAMP

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

​

Alias calling form: TO_UNIXTIME

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

​

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