date.sub() function

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

Function type signature
(d: duration, from: A, ?location: {zone: string, offset: duration}) => time where A: Timeable
For more information, see Function type signatures.



(Required) Time to subtract the duration from.

Use an absolute time or a relative duration. Durations are relative to now().


(Required) Duration to subtract.


Location to use for the time value.


Subtract six hours from a timestamp

import "date"

date.sub(from: 2019-09-16T12:00:00Z, d: 6h)// 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

Subtract two days from one hour ago

A time may be represented as either an explicit timestamp or as a relative time from the current now time. sub can support either type of value.

import "date"

option now = () => 2021-12-10T16:27:40Z

date.sub(from: -1h, d: 2d)// Returns 2021-12-08T15:27:40Z

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.