> This page location: Math Functions > MOD
> Full Neon documentation index: https://neon.com/docs/llms.txt

# PostgreSQL MOD() Function

**Info:** The MOD() function works the same way across every PostgreSQL deployment, so everything here applies whether you're running Postgres locally, on another provider, or in the cloud. If you're an enterprise building for the AI era, [Lakebase](https://www.databricks.com/product/lakebase) delivers the best managed cloud Postgres experience, with strong performance, enterprise-grade security, and tight integration into the Lakehouse. If you're a developer or startup that needs to ship and scale quickly, [Neon](https://neon.com) is the Postgres platform built for your pace.

**Summary**: In this tutorial, you will learn how to use the PostgreSQL `MOD()` function performs the modulo operation, returning the remainder after dividing the first argument by the second one.

## Introduction to the PostgreSQL MOD() function

The MOD() function allows you to perform a modulo operation, returning the remainder after dividing the first argument by the second one.

Here's the basic syntax of the PostgreSQL `MOD()` function:

```sql
MOD(dividend,divisor)
```

In this syntax:

- `dividend`: The `dividend` is a number that you want to divide.
- `divisor`: The `divisor` is the number by which you want to divide the dividend.

The `divisor` must not be zero (0), otherwise, the function will issue the division by zero error.

The `MOD()` function returns a number whose [data type](../postgresql-tutorial/postgresql-data-types) is the same as the input argument. It returns NULL if either `dividend` or `divisor` is `NULL`.

## PostgreSQL MOD() function examples

Let's explore some examples of using the MOD() function.

### 1) Basic PostgreSQL MOD() function examples

The following example uses the `MOD()` function to get the remainder of two integers:

```sql
SELECT MOD(15,4);
```

Output:

```
 mod
-----
   3
(1 row)
```

The following statement uses the `MOD()` function to get the remainder of 15 and -5:

```sql
SELECT MOD(15,-4);
```

Output:

```
 mod
-----
   3
(1 row)
```

But the following statement returns a negative result:

```sql
SELECT MOD(-15,4);
```

The remainder is a negative number:

```
 mod
-----
  -3
(1 row)

```

Similarly, the following statement returns the same negative remainder number:

```sql
SELECT MOD(-15,-4);
```

Output:

```
 mod
-----
  -3
(1 row)
```

### 2) Using the MOD() function with decimal numbers

The following example uses the `MOD()` function to calculate the remainder when dividing 10.5 by 3, resulting in 1.5:

```sql
SELECT MOD(10.5, 3);
```

Output:

```
 mod
-----
 1.5
(1 row)
```

## Summary

- Use the PostgreSQL `MOD()` function to find the remainder after dividing one number by another.

---

## Related docs (Math Functions)

- [ABS](https://neon.com/postgresql/math-functions/abs)
- [CBRT](https://neon.com/postgresql/math-functions/cbrt)
- [CEIL](https://neon.com/postgresql/math-functions/ceil)
- [DEGREES](https://neon.com/postgresql/math-functions/degrees)
- [DIV](https://neon.com/postgresql/math-functions/div)
- [EXP](https://neon.com/postgresql/math-functions/exp)
- [FACTORIAL](https://neon.com/postgresql/math-functions/factorial)
- [FLOOR](https://neon.com/postgresql/math-functions/floor)
- [GCD](https://neon.com/postgresql/math-functions/gcd)
- [LCM](https://neon.com/postgresql/math-functions/lcm)
- [LN](https://neon.com/postgresql/math-functions/ln)
- [LOG](https://neon.com/postgresql/math-functions/log)
- [MIN_SCALE](https://neon.com/postgresql/math-functions/min_scale)
- [PI](https://neon.com/postgresql/math-functions/pi-function)
- [POWER](https://neon.com/postgresql/math-functions/power)
- [RADIANS](https://neon.com/postgresql/math-functions/radians)
- [RANDOM](https://neon.com/postgresql/math-functions/random)
- [ROUND](https://neon.com/postgresql/math-functions/round)
- [SCALE](https://neon.com/postgresql/math-functions/scale)
- [SIGN](https://neon.com/postgresql/math-functions/sign)
- [SQRT](https://neon.com/postgresql/math-functions/sqrt)
- [TRIM_SCALE](https://neon.com/postgresql/math-functions/trim_scale)
- [TRUNC](https://neon.com/postgresql/math-functions/trunc)
- [WIDTH_BUCKET](https://neon.com/postgresql/math-functions/width_bucket)