原英文版地址: https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-functions.html, 原文档版权归 www.elastic.co 所有
本地英文版地址: ../en/sql-functions.html
本地英文版地址: ../en/sql-functions.html
重要: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 当前版本文档。
Functions 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_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
-