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

      year() | Year

      Parameters, Value

      Year function extracts the year of a datetime value and returns that integer.

      Syntax: year(<datetime>)

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

      Constant

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

      return year("2020-01-02 00:05:32")
      

      Function

      Example: Return the year of current system time

      return year(now())
      

      Alias

      Example: find 10 cards, return their expiry year

      find().nodes({@card}) as n
      limit 10
      return year(n.expire_date)
      

      Property

      Example: find 10 cards expiring this year

      find().nodes({year(@card.expire_date) == year(now())}) as n
      limit 10
      return n{*} 
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写