Change Password

Input error
Input error
Input error
Submit

Change Nickname

Current Nickname:
Submit
Search
v4.0
    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
    *
    公司名称不能为空
    *
    公司邮箱必须填写
    *
    你的名字必须填写
    *
    你的电话必须填写
    *
    你的电话必须填写