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

    dateDiff()

    Function dateDiff() calculates the difference of two time values (end time minus start time) and returns that value (take the integer part).

    Arguments:

    • End time <datetime | timestamp | string>
    • Start time <datetime | timestamp | string>
    • Unit <string>, valid options: day, hour, minute, second

    Returns:

    • Time difference <number>

    This function returns a negative value when the end time is earlier than the start time. If the end time and the start time are non-homologous, Cartesian Product will be applied when being called in a WITH clause, or column length will be trimmed when being called in a RETURN clause.

    Constant, Function

    Example: calculate the days from the current system time to 2050 new year.

    return dateDiff("2050-01-01 0:0:0", now(), "day")
    

    Alias

    Example: calculate the number of days Card CA001 has been opened

    find().nodes({_id == "CA001"}) as n
    return dateDiff(now(), n.open_date, "day")
    

    Property

    Example: find 10 @transfer edges within the past year

    find().edges({dateDiff(now(), @transfer.time, "day") <= 365}) as e
    limit 10
    return e{*}
    
    Please complete the following information to download this book
    *
    公司名称不能为空
    *
    公司邮箱必须填写
    *
    你的名字必须填写
    *
    你的电话必须填写
    *
    你的电话必须填写