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{*}