Change Password

Input error
Input error
Input error
Submit

Change Nickname

Current Nickname:
Submit
Search
v4.0
    v4.0

    date_diff() | Time Difference

    Parameters, Value

    Time difference function calculates the time difference between two datetime values (end_datetime - start_datetime) and returns that value (take the integer part).

    If end_date and start_date are not homologous: when used in WITH, date_diff() will first make a Cartesian Product Combination of all columns and its homologous columns before calculation; when used in RETURN, date_diff() will trim all columns and their homologous columns before calculation.

    Syntax:

    • Format: date_diff(<end_date>, <start_date>, "<interval>")
    • Parameters: see table below
    • Function: ATTR (time)
    Name Type Specification Description
    end_datetime ATTR (time) / End of the time
    start_datetime ATTR (time) / Start of the time
    interval String day, hour, minute, second The unit of the returned value

    The returned value is negative if end_datetime is earlier than start_datetime.

    Constant, Function

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

    return date_diff("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 date_diff(now(), n.open_date, "day")
    

    Property

    Example: find 10 @transfer edges within the past year

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