> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL functions

> Every SQL function Query Engine supports, grouped by category, with syntax, arguments, return values and examples.

Query Engine supports 363 SQL functions. Each has its own page with syntax, arguments, return type, NULL behaviour and runnable examples.

Search for a function by name with the search bar, or browse by category.

<Columns cols={2}>
  <Card title="String functions" href="/query/sql/functions/string">63 functions. Search, slice, combine, pad, format and transform text.</Card>
  <Card title="Math functions" href="/query/sql/functions/math">53 functions. Arithmetic, rounding, logarithmic, trigonometric and other numeric functions.</Card>
  <Card title="Date and time functions" href="/query/sql/functions/date-time">78 functions. Build, convert, format, extract from and do arithmetic on dates, times and timestamps.</Card>
  <Card title="Aggregate functions" href="/query/sql/functions/aggregate">48 functions. Compute one result from a set of rows, such as a sum, count, average or approximate distinct count. Most can also run as window functions.</Card>
  <Card title="Window functions" href="/query/sql/functions/window">7 functions. Rank rows and read values from neighbouring rows within a window. Aggregate functions can also run over windows.</Card>
  <Card title="Conditional and conversion functions" href="/query/sql/functions/conditional">23 functions. Branch on conditions, handle NULLs, cast between types and read session context.</Card>
  <Card title="Array functions" href="/query/sql/functions/array">34 functions. Build, inspect, transform and flatten arrays.</Card>
  <Card title="Map functions" href="/query/sql/functions/map">7 functions. Build maps and read their keys, values and entries.</Card>
  <Card title="Struct functions" href="/query/sql/functions/struct">2 functions. Build structs (records with named fields).</Card>
  <Card title="JSON functions" href="/query/sql/functions/json">12 functions. Parse JSON, extract values from it and build JSON output.</Card>
  <Card title="Regular expression functions" href="/query/sql/functions/regex">8 functions. Match, extract and replace text with regular expressions.</Card>
  <Card title="Hash functions" href="/query/sql/functions/hash">5 functions. Compute checksums and cryptographic digests.</Card>
  <Card title="Bitwise functions" href="/query/sql/functions/bitwise">13 functions. Operate on the individual bits of integers.</Card>
  <Card title="Bitmap functions" href="/query/sql/functions/bitmap">1 functions. Work with bitmaps.</Card>
  <Card title="Table functions" href="/query/sql/functions/table">9 functions. Functions that return rows instead of a single value, such as exploding arrays or generating ranges.</Card>
  <Card title="Geospatial functions" href="/query/sql/functions/geospatial">H3 and spatial functions for points, coordinates and polygons.</Card>
</Columns>

For equivalents of these functions in other SQL engines, see [Equivalent functions and operators](/query/sql/function-mapping).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.