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

      day_of_week() | Day of Week

      Parameters, Value

      Day of Week function calculates the day of week of a datetime value and returns that integer, and the correspondence between them is as follows:

      Name Sunday Monday Tuesday Wednesday Thursday Friday Saturday
      Number 1 2 3 4 5 6 7

      Syntax:

      • Format: day_of_week(<date>)
      • Parameters:see list below
      • Value: ATTR (number)
      Name Category Specification Description
      date ATTR(time) / The time value to be extracted from

      Constant

      Example: Return the day of week of "2020-01-02 00:05:32"

      return day_of_week("2020-01-02 00:05:32") as dayOfWeek
      

      Function

      Example: find the day of the week of the current system time

      return day_of_week(now())
      

      Alias

      Example: find 10 @trasnfer edges, return the day of the week of the transfer time

      find().edges({@transfer}) as e
      limit 10
      return day_of_week(e.time)
      

      Property

      Example: find 10 @transfer edges with their transfer time on weekend

      find().edges({day_of_week(@transfer.time) in [1, 7]}) as e
      limit 10
      return e{*} 
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写