docs-v2/content/flux/v0.x/stdlib/universe/timeshift.md

title	description	aliases	menu	weight	flux/v0.x/tags	introduced
timeShift() function	The `timeShift()` function adds a fixed duration to time columns.	/influxdb/v2.0/reference/flux/functions/transformations/shift /influxdb/v2.0/reference/flux/functions/built-in/transformations/shift /influxdb/v2.0/reference/flux/functions/built-in/transformations/timeshift/ /influxdb/v2.0/reference/flux/stdlib/built-in/transformations/timeshift/ /influxdb/cloud/reference/flux/stdlib/built-in/transformations/timeshift/	flux_0_x_ref name parent timeShift universe	102	transformations date/time	0.7.0

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.

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

Parameters

duration

({{< req >}}) The amount of time to add to each time value. May be a negative duration.

columns

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

tables

Input data. Default is piped-forward data (<-).

Examples

{{% flux/sample-example-intro plural=true %}}

• Shift timestamps forward in time
• Shift timestamps backward in time

Shift timestamps forward in time

import "sampledata"

sampledata.int()
    |> timeShift(duration: 12h)

{{< expand-wrapper >}} {{% expand "View input and output" %}} {{< flex >}} {{% flex-content %}}

Input data

{{% flux/sample "int" %}}

{{% /flex-content %}} {{% flex-content %}}

Output data

_time	tag	_value
2021-01-01T12:00:00Z	t1	-2
2021-01-01T12:00:10Z	t1	10
2021-01-01T12:00:20Z	t1	7
2021-01-01T12:00:30Z	t1	17
2021-01-01T12:00:40Z	t1	15
2021-01-01T12:00:50Z	t1	4

_time	tag	_value
2021-01-01T12:00:00Z	t2	19
2021-01-01T12:00:10Z	t2	4
2021-01-01T12:00:20Z	t2	-3
2021-01-01T12:00:30Z	t2	19
2021-01-01T12:00:40Z	t2	13
2021-01-01T12:00:50Z	t2	1
{{% /flex-content %}}
{{< /flex >}}
{{% /expand %}}
{{< /expand-wrapper >}}

Shift timestamps backward in time

import "sampledata"

sampledata.int()
    |> timeShift(duration: -12h)

{{< expand-wrapper >}} {{% expand "View input and output" %}} {{< flex >}} {{% flex-content %}}

Input data

{{% flux/sample "int" %}}

{{% /flex-content %}} {{% flex-content %}}

Output data

_time	tag	_value
2020-12-31T12:00:00Z	t1	-2
2020-12-31T12:00:10Z	t1	10
2020-12-31T12:00:20Z	t1	7
2020-12-31T12:00:30Z	t1	17
2020-12-31T12:00:40Z	t1	15
2020-12-31T12:00:50Z	t1	4

_time	tag	_value
2020-12-31T12:00:00Z	t2	19
2020-12-31T12:00:10Z	t2	4
2020-12-31T12:00:20Z	t2	-3
2020-12-31T12:00:30Z	t2	19
2020-12-31T12:00:40Z	t2	13
2020-12-31T12:00:50Z	t2	1
{{% /flex-content %}}
{{< /flex >}}
{{% /expand %}}
{{< /expand-wrapper >}}