# log10

> 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: log10
latest-operator-version: v26.2.4
latest-console-tag: v3.12.0
latest-connect-version: 4.113.1
latest-redpanda-tag: v26.2.4
docname: sql/sql-functions/math-functions/log10
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/math-functions/log10.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/math-functions/log10.adoc
description: The `log10()` function returns the base-10 logarithm of a given number.
page-topic-type: reference
page-git-created-date: "2026-09-08"
page-git-modified-date: "2026-09-08"
---

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

The `log10()` function returns the base-10 logarithm of a given number. It is equivalent to calling [`log()`](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/math-functions/log/) with a single argument.

## [](#syntax)Syntax

```sql
LOG10(x)
```

## [](#arguments)Arguments

-   `x`: A positive number of type `real` or `double precision`.


## [](#return-type)Return type

Same as the input type (`real` or `double precision`).

## [](#examples)Examples

### [](#basic-usage)Basic usage

```sql
SELECT LOG10(1000);
```

```sql
 log10
-------
     3
(1 row)
```

### [](#fractional-result)Fractional result

```sql
SELECT LOG10(2);
```

```sql
        log10
--------------------
 0.3010299956639812
(1 row)
```