elasticsearch/docs/reference/query-languages/esql/_snippets/functions/examples/round_to.md

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

Example

FROM employees
| STATS COUNT(*) BY birth_window=ROUND_TO(
    birth_date,
    "1900-01-01T00:00:00Z"::DATETIME,
    "1950-01-01T00:00:00Z"::DATETIME,
    "1955-01-01T00:00:00Z"::DATETIME,
    "1960-01-01T00:00:00Z"::DATETIME,
    "1965-01-01T00:00:00Z"::DATETIME,
    "1970-01-01T00:00:00Z"::DATETIME,
    "1975-01-01T00:00:00Z"::DATETIME
)
| SORT birth_window ASC

COUNT(*):long	birth_window:datetime
27	1950-01-01T00:00:00Z
29	1955-01-01T00:00:00Z
33	1960-01-01T00:00:00Z
1	1965-01-01T00:00:00Z
10	null