IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
Functions and Operators
editFunctions and Operators
editElasticsearch SQL provides a comprehensive set of built-in operators and functions:
- Date-Time Operators
-
-
CURRENT_DATE/CURDATE
-
CURRENT_TIME/CURTIME
-
CURRENT_TIMESTAMP
-
DATE_ADD/DATEADD/TIMESTAMP_ADD/TIMESTAMPADD
-
DATE_DIFF/DATEDIFF/TIMESTAMP_DIFF/TIMESTAMPDIFF
-
DATE_PART/DATEPART
-
DATE_TRUNC/DATETRUNC
-
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
-