Functions/Database & utility/nanosecond
Database & utility Scalar

nanosecond()

Extract the nanosecond component from a date or timestamp

Arguments & returns

7 overloads

nanosecond(tsns)

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

Example

nanosecond example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.