Dates & time Scalar

to_timestamp()

Converts secs since epoch to a timestamp with time zone

Arguments & returns

Scalar

Overload link	`sec`	Returns
#01	`DOUBLE`	`TIMESTAMP WITH TIME ZONE`

SELECT to_timestamp(1284352323.5);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

FROM_UNIXTIME(x)

In Haybarn

TO_TIMESTAMP(x)

SELECT TO_TIMESTAMP(1659981729000000000, 9)

In Haybarn

SELECT TO_TIMESTAMP(1659981729000000000 / POWER(10, 9)) AT TIME ZONE 'UTC'

Used in larger rewrites 2

These examples use to_timestamp as one part of a larger SQL translation.

from_unixtime(x, "yyyy-MM-dd'T'HH")

In Haybarn

STRFTIME(TO_TIMESTAMP(x), '%Y-%m-%d''T''%H')

SELECT TIMESTAMP_DIFF(TIMESTAMP_SECONDS(60), TIMESTAMP_SECONDS(0), minute)

In Haybarn

SELECT DATE_DIFF('MINUTE', TO_TIMESTAMP(0), TO_TIMESTAMP(60))