DATE_TRUNCedit
Rounds down a date to the closest interval. Intervals can be expressed using the timespan literal syntax.
FROM employees | EVAL year_hired = DATE_TRUNC(1 year, hire_date) | STATS count(emp_no) BY year_hired | SORT year_hired