elasticsearch/docs/reference/query-languages/esql/esql-functions-operators.md

---

applies_to: stack: serverless: navigation_title: "Functions and operators" mapped_pages:

• https://www.elastic.co/guide/en/elasticsearch/reference/current/esql-functions-operators.html ---

{{esql}} functions and operators [esql-functions-operators]

{{esql}} provides a comprehensive set of functions and operators for working with data. The reference documentation is divided into the following categories:

Functions overview [esql-functions]

::::{dropdown} Aggregate functions :open: :::{include} _snippets/lists/aggregation-functions.md ::: ::::

::::{dropdown} Time-series aggregate functions :open: :::{include} _snippets/lists/time-series-aggregation-functions.md ::: ::::

::::{dropdown} Grouping functions :open: :::{include} _snippets/lists/grouping-functions.md ::: ::::

::::{dropdown} Conditional functions and expressions :open: :::{include} _snippets/lists/conditional-functions-and-expressions.md ::: ::::

::::{dropdown} Date and time functions :open: :::{include} _snippets/lists/date-time-functions.md ::: ::::

::::{dropdown} IP functions :open: :::{include} _snippets/lists/ip-functions.md ::: ::::

::::{dropdown} Math functions :open: :::{include} _snippets/lists/math-functions.md ::: ::::

::::{dropdown} Search functions :open: :::{include} _snippets/lists/search-functions.md ::: ::::

::::{dropdown} Spatial functions :open: :::{include} _snippets/lists/spatial-functions.md ::: ::::

::::{dropdown} String functions :open: :::{include} _snippets/lists/string-functions.md ::: ::::

::::{dropdown} Type conversion functions :open: :::{include} _snippets/lists/type-conversion-functions.md ::: ::::

::::{dropdown} Multi value functions :open: :::{include} _snippets/lists/mv-functions.md ::: ::::

Operators overview [esql-operators-overview]

::::{dropdown} Operators :open: :::{include} _snippets/lists/operators.md ::: ::::