Dates & time
Scalar
make_timestamp_ns()
The timestamp for the given nanoseconds since epoch
Arguments & returns
make_timestamp_ns(nanos)
Scalar
| Overload link | nanos |
Returns |
|---|---|---|
| #01 | BIGINT |
TIMESTAMP_NS |
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
Catalog examples
SELECT
make_timestamp(1732117793000000000);In other engines
Snowflakedateadd()
DATEADD(NANOSECOND, nano_offset, timestamp_col)
In DuckDBMAKE_TIMESTAMP_NS(EPOCH_NS(CAST(timestamp_col AS TIMESTAMP_NS)) + nano_offset)