Manipulate timestamps with Flux

Every point stored in InfluxDB has an associated timestamp. Use Flux to process and manipulate timestamps to suit your needs.

Convert timestamp format

Convert nanosecond epoch timestamp to RFC3339

Use the time() function to convert a nanosecond epoch timestamp to an RFC3339 timestamp.

time(v: 1568808000000000000)
// Returns 2019-09-18T12:00:00.000000000Z

Convert RFC3339 to nanosecond epoch timestamp

Use the uint() function to convert an RFC3339 timestamp to a nanosecond epoch timestamp.

uint(v: 2019-09-18T12:00:00.000000000Z)
// Returns 1568808000000000000

Calculate the duration between two timestamps

Flux doesn’t support mathematical operations using time type values. To calculate the duration between two timestamps:

  1. Use the uint() function to convert each timestamp to a nanosecond epoch timestamp.
  2. Subtract one nanosecond epoch timestamp from the other.
  3. Use the duration() function to convert the result into a duration.
time1 = uint(v: 2019-09-17T21:12:05Z)
time2 = uint(v: 2019-09-18T22:16:35Z)

duration(v: time2 - time1)
// Returns 25h4m30s

Flux doesn’t support duration column types. To store a duration in a column, use the string() function to convert the duration to a string.

Retrieve the current time

Use the now() function to return the current UTC time in RFC3339 format.

now()

Add a duration to a timestamp

The experimental.addDuration() function adds a duration to a specified time and returns the resulting time.

By using experimental.addDuration(), you accept the risks of experimental functions.

import "experimental"

experimental.addDuration(
  d: 6h,
  to: 2019-09-16T12:00:00Z,
)

// Returns 2019-09-16T18:00:00.000000000Z

Subtract a duration from a timestamps

The experimental.addDuration() function subtracts a duration from a specified time and returns the resulting time.

By using experimental.addDuration(), you accept the risks of experimental functions.

import "experimental"

experimental.subDuration(
  d: 6h,
  from: 2019-09-16T12:00:00Z,
)

// Returns 2019-09-16T06:00:00.000000000Z

This documentation is open source. See a typo? Please, open an issue.


Need help getting up and running? Get Support