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.3
Search
    中文EN
    v4.3

      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>

      Common Usage

      Example: Direct calculate

      uncollect ["2023-04-30 22:00:00", "2023-01-15 22:00:00"] as a
      uncollect [2, -30] as b
      uncollect ["day", "minute"] as c
      return table(a, b, c, dateAdd(a, b, c))
      

      |          a          |  b  |    c   |   dateAdd(a, b, c)  |
      |---------------------|-----|--------|---------------------|
      | 2023-04-30 22:00:00 |  2  | day    | 2023-05-02 22:00:00 |
      | 2023-01-15 22:00:00 | -30 | minute | 2023-01-15 21:30:00 |
      

      Example: Multiply and calculate

      uncollect ["2023-04-30 22:00:00", "2023-01-15 22:00:00"] as a
      uncollect [2, -30] as b
      uncollect ["day", "minute"] as c
      with dateAdd(a, b, c) as d
      return table(a, b, c, d)
      

      |          a          |  b  |    c   |          d          |
      |---------------------|-----|--------|---------------------|
      | 2023-04-30 22:00:00 |  2  | day    | 2023-05-02 22:00:00 |
      | 2023-04-30 22:00:00 |  2  | minute | 2023-04-30 22:02:00 |
      | 2023-04-30 22:00:00 | -30 | day    | 2023-03-31 22:00:00 |
      | 2023-04-30 22:00:00 | -30 | minute | 2023-04-30 21:30:00 |
      | 2023-01-15 22:00:00 |  2  | day    | 2023-01-17 22:00:00 |
      | 2023-01-15 22:00:00 |  2  | minute | 2023-01-15 22:02:00 |
      | 2023-01-15 22:00:00 | -30 | day    | 2022-12-16 22:00:00 |
      | 2023-01-15 22:00:00 | -30 | minute | 2023-01-15 21:30:00 |
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写