Navigation
This version of the documentation is archived and no longer supported.
Date Aggregation Operators
Name |
Description |
$dayOfYear |
Converts a date to a number between 1 and 366. |
$dayOfMonth |
Converts a date to a number between 1 and 31. |
$dayOfWeek |
Converts a date to a number between 1 and 7. |
$year |
Converts a date to the full year. |
$month |
Converts a date into a number between 1 and 12. |
$week |
Converts a date into a number between 0 and 53 |
$hour |
Converts a date into a number between 0 and 23. |
$minute |
Converts a date into a number between 0 and 59. |
$second |
Converts a date into a number between 0 and 59. May be 60 to account for leap seconds. |
$millisecond |
Returns the millisecond portion of a date as an integer between 0 and 999. |