Function dateAdd() returns a new time shifted from the original time.

Arguments：

• Original time <datetime | timestamp | string>
• Offset <number>
• Offset unit <string>, valid options: year, month, day, hour, minute, second

Returns：

• New time <datetime | timestamp | datetime>

Constant

Example: return time value of the date 90 days later than "2022-04-30 22:12:54"

return dateAdd("2022-04-30 22:12:54", 90, "day")

Function

Example: return time value 5 hours earlier than current system time

return dateAdd(now(), -5, "hour")

Alias

Example: find 10 @transfer edges, return transfer time as their eastern neighbor time zones'

find().edges({@transfer}) as e
limit 10
return dateAdd(e.time, 1, "hour")

Property

Example: find 10 @transfer edges within a year till now

find().edges({dateAdd(@transfer.time, 1, "year") >= now()}) as e
limit 10
return e{*}

Compound Offset

Example：Defer the current system time for 3 days and shift earlier by 5 hours

update().edges({no == "TRX001"})
  .set({time: dateAdd(dateAdd(time, 3, "day"), -5, "hour")}) as edges
return edges{*}