UNIX_TIMESTAMP

​

Syntax

​

Unix timestamp timestamp (scalar)

unix_timestamp(value)

​

Unix timestamp parsed (scalar)

unix_timestamp(value, format)

​

Arguments

​

Unix timestamp timestamp

​

Unix timestamp parsed

​

Returns

• 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

​

Alias calling form: UNIX_TIMESTAMP

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

​

Unix epoch and one second later

SELECT unix_timestamp(TIMESTAMP '1970-01-01 00:00:00') AS epoch, unix_timestamp(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