---
title: Functions Overview
slug: T6hItDY7Y1c8jNFKBbu-o
description: Explore Ocient function library for data analysis, manipulation, and transformations, empowering complex querying and calculations.
docTags: 
createdAt: Thu Jul 21 2022 17:05:13 GMT+0000 (Coordinated Universal Time)
updatedAt: Thu Apr 02 2026 16:32:40 GMT+0000 (Coordinated Universal Time)
---

Ocient® includes many functions for statistics, mathematics, string manipulation, and working with complex types like Arrays and geospatial data. The following types of functions are supported:

## SQL Functions

### Math and Arithmetic Functions

Perform mathematical operations on data in Ocient, including basic operators on data types and advanced statistical functions.

- [Math Functions and Operators](<././SQL Reference/Math Functions and Operators.md>)&#x20;
- [Aggregate Functions](<././SQL Reference/Aggregate Functions.md>)&#x20;

### Character and Binary Functions

Manipulate character strings and binary data types and use character operators to query character data.

- [Character and Binary Functions](<././SQL Reference/Character and Binary Functions.md>)&#x20;

### Conversion and Formatting Functions

Convert data types with scalar conversions and format numbers and times in character outputs.

- [Scalar Data Conversion Functions](<././SQL Reference/Scalar Data Conversion Functions.md>)&#x20;
- [Formatting Functions](<././SQL Reference/Formatting Functions.md>)&#x20;

### Date and Time Functions

Perform date operations in Ocient, including manipulation and comparison of date and time types. Date and Time functions allow users to add, subtract, and truncate date time values and intervals.

- [Date and Time Functions](<././SQL Reference/Date and Time Functions.md>)&#x20;
- [Time Zone Functions](<././SQL Reference/Time Zone Functions.md>)

### Aggregates

Aggregates include basic aggregates and sorted aggregates that combine many rows into a single result, as well as window aggregates that combine information from multiple rows within the window into each row in the result set.

- [Aggregate Functions](<././SQL Reference/Aggregate Functions.md>)&#x20;
- [Window Aggregate Functions](<././SQL Reference/Window Aggregate Functions.md>)&#x20;
- [HyperLogLog Functions](<././SQL Reference/HyperLogLog Functions.md>)

### Array, Tuple, and Matrix Functions

Special functions and operators to work with container types. These include operators to check set logic, slice, compare, and manipulate arrays, tuples, and matrices.

- [Array Functions and Operators](<././SQL Reference/Array Functions and Operators.md>)&#x20;
- [Tuple Functions and Operators](<././SQL Reference/Tuple Functions and Operators.md>)&#x20;
- [Matrix Functions and Operators](<././SQL Reference/Matrix Functions and Operators.md>)&#x20;

### Geospatial Functions

Functions and Operators to manipulate and compare points, linestrings, and polygons.

- [Geospatial Functions](<././SQL Reference/Geospatial Functions.md>)&#x20;

### Network Functions

Functions for using network data types, including `IP` and `IPV4`.

- [Network Type Functions](<././SQL Reference/Network Type Functions.md>)

### Miscellaneous Functions

A set of functions such as `CASE`, `CURRENT_USER`, and `NULL_IF` that provide additional capabilities in Ocient.

- [Other Functions and Expressions](<././SQL Reference/Other Functions and Expressions.md>)&#x20;

## Related Links

[SQL Reference](<././SQL Reference.md>)

[General SQL Syntax](<./General SQL Syntax.md>)
