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

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File
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
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写