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())



Duration to subtract.


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


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.