NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.
Functions and Operators
edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.
Functions and Operators
editElasticsearch SQL provides a comprehensive set of built-in operators and functions:
- Date-Time Operators
-
-
CURRENT_DATE/CURDATE -
CURRENT_TIMESTAMP -
DAY_OF_MONTH/DOM/DAY -
DAY_OF_WEEK/DAYOFWEEK/DOW -
DAY_OF_YEAR/DOY -
DAY_NAME/DAYNAME -
HOUR_OF_DAY/HOUR -
ISO_DAY_OF_WEEK/ISODAYOFWEEK/ISODOW/IDOW -
ISO_WEEK_OF_YEAR/ISOWEEKOFYEAR/ISOWEEK/IWOY/IW -
MINUTE_OF_DAY -
MINUTE_OF_HOUR/MINUTE -
MONTH_OF_YEAR/MONTH -
MONTH_NAME/MONTHNAME -
NOW -
SECOND_OF_MINUTE/SECOND -
QUARTER -
TODAY -
WEEK_OF_YEAR/WEEK -
YEAR -
EXTRACT
-