> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/gridgain/gridgain-8/reference/sql/functions.md).

# Functions

The SQL functions supported by GridGain 8, grouped by category — aggregate, numeric, string, date and time, JSON, and system functions.

GridGain 8 supports the following categories of SQL functions.

{% columns %}
{% column %}
{% content-ref url="/pages/tk0IX7sIyWYlsr6FlxSm" %}
[Aggregate Functions](/docs/gridgain/gridgain-8/reference/sql/functions/aggregate-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL aggregate functions supported by GridGain — AVG, BIT\_AND, BIT\_OR, COUNT, GROUP\_CONCAT, MAX, MIN, SUM, and statistical aggregates.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/jHwIyk8QJtcGyQCtTHWy" %}
[JSON Functions](/docs/gridgain/gridgain-8/reference/sql/functions/json-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL JSON functions supported by GridGain — IS\_JSON, JSON\_ARRAY, JSON\_MODIFY, JSON\_OBJECT, JSON\_QUERY, and JSON\_VALUE.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/G7IT03qVMcAT9gVxG2Jd" %}
[Numeric Functions](/docs/gridgain/gridgain-8/reference/sql/functions/numeric-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL numeric functions supported by GridGain — trigonometric, logarithmic, bitwise, rounding, random, encryption, and compression functions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/q3ZVYJgjsz4XaGXJjIuk" %}
[String Functions](/docs/gridgain/gridgain-8/reference/sql/functions/string-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL string functions supported by GridGain — length, case, padding, trimming, search/replace, regular-expression, and XML functions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/eEtRU4en1ni6ORqalFce" %}
[Date and Time Functions](/docs/gridgain/gridgain-8/reference/sql/functions/date-time-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL date and time functions supported by GridGain — current date/time, DATEADD, DATEDIFF, EXTRACT, formatting, and component extraction.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/vTGx4P1KUbynZX6psH3d" %}
[System Functions](/docs/gridgain/gridgain-8/reference/sql/functions/system-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL system functions supported by GridGain — CASEWHEN, CAST, COALESCE, CONVERT, DECODE, GREATEST, IFNULL, LEAST, NULLIF, NVL2, and TABLE.
{% endcolumn %}
{% endcolumns %}