Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of uppercase, lowercase, numbers, and special characters (such as @*&#).
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

v4.2
Search
中文EN
v4.2

    dateAdd()

    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{*}
    
    Please complete the following information to download this book
    *
    公司名称不能为空
    *
    公司邮箱必须填写
    *
    你的名字必须填写
    *
    你的电话必须填写
    *
    你的电话必须填写