Dates & time
Scalar
epoch()
Extract the epoch component from a temporal type
Reference: DuckDB 2.0.0
Arguments & returns
7 overloadsepoch(temporal)
Scalar
epoch(ts)
Scalar
| Overload link | ts |
Returns |
|---|---|---|
| #07 | TIMESTAMP WITH TIME ZONE |
DOUBLE |
Example
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example ยท Run to view results.
In other engines
Apache Hiveunix_timestamp()
UNIX_TIMESTAMP(x)
EPOCH(STRPTIME(x, '%Y-%m-%d %H:%M:%S'))
Apache Sparkunix_timestamp()
SELECT UNIX_TIMESTAMP('2016-1-1', 'yyyy-M-d')
SELECT EPOCH(STRPTIME('2016-1-1', '%Y-%-m-%-d'))
BigQueryunix_seconds()
SELECT UNIX_SECONDS('2008-12-25 15:30:00+00')
SELECT CAST(EPOCH(CAST('2008-12-25 15:30:00+00' AS TIMESTAMPTZ)) AS BIGINT)
Snowflakedate_part()
SELECT DATE_PART(epoch_second, foo) as ddate from table_name
SELECT CAST(EPOCH(foo) AS BIGINT) AS ddate FROM table_name