InfluxDB Docs

truncateTimeColumn() function

The truncateTimeColumn() function truncates all input table _time values to a specified unit.

Function type: Transformation

truncateTimeColumn(unit: 1s)

Parameters

unit

The unit of time to truncate to.

Data type: Duration

Only use 1 and the unit of time to specify the unit. For example: 1s, 1m, 1h.

Examples

Truncate all time values to seconds
from(bucket:"example-bucket")
  |> range(start:-1h)
  |> truncateTimeColumn(unit: 1s)

Function definition

import "date"

truncateTimeColumn = (unit, tables=<-) =>
  tables
    |> map(fn: (r) => ({
        r with _time: date.truncate(t: r._time, unit:unit)
      })
    )