ES|QL DAY function
Extracts the day of month from a date.
date-
Date expression. If
null, the function returnsnull.
Extracts the day of month (1-31) from a date, using the query time zone. Equivalent to DATE_EXTRACT("day_of_month", 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: DAY(ts) > 15 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 day = DAY(dt)