Dates & time Scalar

epoch()

Extract the epoch component from a temporal type

Arguments & returns

7 overloads

Scalar

SELECT epoch(timestamp '2021-08-03 11:59:44.123456');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

UNIX_TIMESTAMP(x)

In DuckDB

EPOCH(STRPTIME(x, '%Y-%m-%d %H:%M:%S'))

SELECT UNIX_TIMESTAMP('2016-1-1', 'yyyy-M-d')

In DuckDB

SELECT EPOCH(STRPTIME('2016-1-1', '%Y-%-m-%-d'))

SELECT UNIX_SECONDS('2008-12-25 15:30:00+00')

In DuckDB

SELECT CAST(EPOCH(CAST('2008-12-25 15:30:00+00' AS TIMESTAMPTZ)) AS BIGINT)

TO_UNIXTIME(x)

In DuckDB

EPOCH(x)

SELECT DATE_PART(epoch_second, foo) as ddate from table_name

In DuckDB

SELECT CAST(EPOCH(foo) AS BIGINT) AS ddate FROM table_name