Documentation

timeShift() function

The timeShift() function adds a fixed duration to time columns. The output table schema is the same as the input table. If the time is null, the time will continue to be null.

Function type: Transformation

timeShift(duration: 10h, columns: ["_start", "_stop", "_time"])

Parameters

duration

The amount of time to add to each time value. May be a negative duration.

Data type: Duration

columns

The list of all columns to be shifted. Defaults to ["_start", "_stop", "_time"].

Data type: Array of strings

Examples

Shift forward in time
from(bucket: "example-bucket")
	|> range(start: -5m)
	|> timeShift(duration: 12h)
Shift backward in time
from(bucket: "example-bucket")
	|> range(start: -5m)
	|> timeShift(duration: -12h)

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: