TimeAdd
TimeAdd( base, offset, unit )
TimeAdd( base, offset, unit )
time_add( base, offset, unit )
TimeAdd( base, offset, unit )
Parameters
Parameter | Type | Definition and Requirements |
---|---|---|
|
Timestamp or Date |
A timestamp or date to add to. |
|
Integer or Long |
The integer number of |
|
String |
Unit of the When When
|
Returns
When base
is a Date, a new Date which represents base
with offset
unit
s added to it.
When base
is a Timestamp, a new Timestamp which
represents base
with offset
unit
s added to it.
Examples
The following query returns a Timestamp representing one day after the Unix epoch:
{0 62135683201 <nil>}
Time("1970-01-02T00:00:00Z")
FaunaTime('1970-01-02T00:00:01Z')
Time("1970-01-02T00:00:00Z")
The following query returns a Timestamp 5 seconds in the future from now:
[{183000000 63746604242 <nil>} {183000000 63746604247 <nil>}]
[ Time("2019-10-22T16:45:19.223863Z"),
Time("2019-10-22T16:45:24.223863Z") ]
[FaunaTime('2021-01-18T22:04:09.121Z'), FaunaTime('2021-01-18T22:04:14.121Z')]
[ Time("2021-06-23T12:23:09.348Z"), Time("2021-06-23T12:23:14.348Z") ]
The following query returns a Date 1 day after 2019-11-26:
{0 63710409600 <nil>}
Date("2019-11-27")
2019-11-27
Date("2019-11-27")
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!