nanosecond()

Extract the nanosecond component from a date or timestamp

Reference: DuckDB 2.0.0

Arguments & returns

9 overloads

nanosecond(tsns)

Scalar
Overload link tsns Returns
#01 DATE BIGINT
#02 INTERVAL BIGINT
#03 TIME BIGINT
#04 TIME WITH TIME ZONE BIGINT
#05 TIME_NS BIGINT
#06 TIMESTAMP BIGINT
#07 TIMESTAMP WITH TIME ZONE BIGINT
#08 TIMESTAMP_NS BIGINT
#09 TIMESTAMPTZ_NS BIGINT

Example

nanosecond example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.