The day() function extracts the day of the month from a time value.
day(time)
Augment | Type | Description |
|---|---|---|
time | Datetime, timestamp, string | The time value |
Return type: Integer
UQLreturn day("2022-10-05")
Result: 5
Retrieve reviews posted on 11 October each year.
UQLfind().nodes({month(@review.time) == 10 && day(@review.time) == 11}) as n return n{*}