Advanced Elasticsearch 7.0

Date-time

The following table lists the functions supported with their descriptions:

Function name	Description
INTERVAL	This is a keyword, but it works like a function to convert the subsequent literal into a date-time interval.
CURRENT_DATE/ CURRENT_DATE()/ CURDATE()	Returns the current date of the server. It can be used as a keyword instead of a function.
CURRENT_TIMESTAMP/ CURRENT_TIMESTAMP(precision)	Returns the current date/time of the server. The precision (defaults to 3) is the number of digits rounded off to nanoseconds. It can be used as a keyword instead of a function.
DAY_OF_MONTH(expr)/ DOM(expr)/ DAY(expr)	Returns the day of the month from expr.
DAY_OF_WEEK(expr)/ DAYOFWEEK(expr)/ DOW(expr)