This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
Functions and Operators
editFunctions and Operatorsedit
Elasticsearch 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_FORMAT
-
DATE_PARSE
-
DATETIME_FORMAT
-
DATETIME_PARSE
-
FORMAT
-
DATE_PART/DATEPART
-
DATE_TRUNC/DATETRUNC
-
DAY_OF_MONTH/DOM/DAY
-
DAY_OF_WEEK/DAYOFWEEK/DOW
-
DAY_OF_YEAR/DOY
-
DAY_NAME/DAYNAME
-
EXTRACT
-
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
-
TIME_PARSE
-
TO_CHAR
-
TODAY
-
WEEK_OF_YEAR/WEEK
-
YEAR
-