Parameters, Value
Day function extracts the day of a datetime value and returns that integer.
Syntax:
- Format: day(
<date>
) - Parameters: see table below
- Value: ATTR (number)
Name | Category | Specification | Description |
---|---|---|---|
date | ATTR(time) | / | The tiem value to be extracted from |
Constant
Example: return the day of "2020-01-02 00:05:32"
return day("2020-01-02 00:05:32")
Function
Example: return the day of current system time
return day(now())
Alias
Example: find 10 cards, return their open days
return day(now())
Property
Example: find 10 cards that were opened on 5th in random months
find().nodes({day(@card.open_date) == 5}) as n
limit 10
return n{*}