InfluxDB Docs

date.nanosecond() function

The date.nanosecond() function returns the nanosecond of a specified time. Results range from [0-999999999].

Function type: Transformation

import "date"

date.nanosecond(t: 2019-07-17T12:05:21.012934584Z)

// Returns 12934584



The time to operate on. Use an absolute time, relative duration, or integer. Durations are relative to now(). Integers are nanosecond Unix timestamps.

Data type: Time | Duration | Integer


Return the nanosecond for a time value
import "date"

date.nanosecond(t: 2020-02-11T12:21:03.293534940Z)

// Returns 293534940Z
Return the nanosecond for a relative duration
import "date"

option now = () => 2020-02-11T12:21:03.293534940Z

date.nanosecond(t: -2111984ns)

// Returns 291422956
Return the nanosecond for a nanosecond Unix timestamp
import "date"

date.nanosecond(t: 1581423663293534940)

// Returns 293534940Z

New! Cloud or OSS?