# SQL Functions

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: SQL Functions
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/index
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/index.adoc
description: Redpanda SQL supports the following function types for querying and transforming data.
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions.md -->

Redpanda SQL supports the following function types for querying and transforming data:

| Function Name | Description |
| --- | --- |
| Boolean functions | Evaluate logical conditions and return TRUE, FALSE, or NULL. |
| Math, trigonometric, and hyperbolic functions | Perform mathematical operations on numeric data, including rounding, exponentiation, and trigonometric calculations. |
| String functions | Manipulate string data for text processing, including concatenation, substring extraction, and case conversion. |
| Timestamp functions | Handle date and time values, including extracting components, adding intervals, and comparing timestamps. |
| JSON functions | Manipulate and query JSON data stored in the database, including extracting values and creating JSON objects. |
| Aggregate functions | Summarize a set of values and return a single result, such as calculating sums, averages, and counts. |
| Window functions | Operate over a subset of rows defined by a windowing clause, enabling ranking, aggregation, and row numbering within result sets. |
| Other functions | Includes a variety of specialized functions not categorized elsewhere. |