Documentation

date.sub() function

date.sub() subtracts a duration from a time value and returns the resulting time value.

import "date"

date.sub(d: 12h, from: now())

Parameters

d

Duration to subtract.

from

Time to subtract the duration from. Use an absolute time or a relative duration. Durations are relative to now().

Examples

Subtract six hours from a timestamp

import "date"

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

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

Subtract six hours from a relative duration

import "date"

option now = () => 2022-01-01T12:00:00Z

date.sub(d: 6h, from: -3h)

// Returns 2022-01-01T03:00:00.000000000Z

Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.