Functions/Database & utility/nanosecond

Database & utility Scalar

nanosecond()

Extract the nanosecond component from a date or timestamp

Arguments & returns

8 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`

Example

SELECT nanosecond(timestamp_ns '2021-08-03 11:59:44.123456789');

Haybarn WASM 1.5.6-rc6 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3