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_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
-