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