`TimeSubtract`

TimeSubtract( base, offset, unit )

Description

The TimeSubtract function decreases a base Timestamp or Date by subtracting the offset in units.

Parameter Type Definition and Requirements

Parameter	Type	Definition and Requirements
`base`	Timestamp or Date	A Timestamp or Date to subtract from. `base` must match the type of `unit`.
`offset`	Integer or Long	The integer number of `unit`s to subtract from `base`.
`unit`	String	Unit of the `offset`. When `base` is a Date, `unit` must be one of `day` or `days`. When `base` is a Timestamp, `unit` must be one of: `day`, or `days` `half day`, or `half days` `hour`, or `hours` `minute`, or `minutes` `second`, or `seconds` `millisecond`, or `milliseconds` `microsecond`, or `microseconds` `nanosecond`, or `nanoseconds`

base

A Timestamp or Date to subtract from. base must match the type of unit.

offset

The integer number of units to subtract from base.

unit

Unit of the offset.

When base is a Date, unit must be one of day or days.

When base is a Timestamp, unit must be one of:

When base is a Date, a new Date which represents base with offset units subtracted from it.

When base is a Timestamp, a new Timestamp which represents base with offset units subtracted from it.

The following query subtracts 1 second from 1 day after Unix epoch:

TimeSubtract(Epoch(1, 'day'), 1, 'second')

Time("1970-01-01T23:59:59Z")

Query metrics:

The following query returns a Timestamp 5 seconds in the past before now:

[
  Now(),
  TimeSubtract(Now(), 5, 'seconds')
]

[ Time("2021-06-23T12:24:16.798Z"), Time("2021-06-23T12:24:11.798Z") ]

Query metrics:

The following query returns a Date 1 day before 2019-11-26:

TimeSubtract(Date('2019-11-26'), 1, 'day')

Date("2019-11-25")

Query metrics:

Is this article helpful?

Tell Fauna how the article can be improved:
Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!