ES|QL HOUR function
Extracts the hour of day from a date.
date-
Date expression. If
null, the function returnsnull.
Extracts the hour of day (0-23) from a date, using the query time zone. Equivalent to DATE_EXTRACT("hour_of_day", date). This function accepts a date or date_nanos value. Unix timestamps in seconds must be converted first. For example: TO_DATETIME(start * 1000). This extract is cyclic: HOUR(ts) > 9 is not rewritten to a timestamp range.
| date | result |
|---|---|
| date | long |
| date_nanos | long |
ROW dt = to_datetime("1996-03-21T00:00:00.000Z")
| EVAL hour = HOUR(dt)