ES|QL YEAR function
Extracts the year from a date.
date-
Date expression. If
null, the function returnsnull.
Extracts the calendar year from a date, using the query time zone. Equivalent to DATE_EXTRACT("year", date). This function accepts a date or date_nanos value. Unix timestamps in seconds must be converted first. For example: TO_DATETIME(start * 1000).
| date | result |
|---|---|
| date | long |
| date_nanos | long |
ROW dt = to_datetime("1996-03-21T00:00:00.000Z")
| EVAL year = YEAR(dt)