# PostgreSQL DIV() function

## DIV() function

The PostgreSQL DIV() function is used to return the integer quotient of a division as specified in the argument. This means it performs division between two numbers and returns the whole number part of the result, discarding any remainder.

##### Uses of DIV() Function
• Integer Division: To perform integer division where only the quotient is needed.

• Mathematical Simplification: To simplify mathematical operations in queries that require the quotient of a division.

• Financial Calculations: Useful in financial calculations where fractional parts are not required.

• Grouping and Batching: Can be used to determine the number of complete groups or batches when dividing items into groups.

Syntax:

```div()
```

PostgreSQL Version: 9.3

Pictorial presentation of PostgreSQL DIV() function

Example: PostgreSQL DIV() function

Code:

``````SELECT DIV(19,3) AS "Quotient";
```
```

Sample Output:

``` Quotient
----------
6
(1 row)
```

Example: PostgreSQL DIV() function using negative value

Code:

``````SELECT DIV(-27,5) AS "Quotient";
```
```

Sample Output:

``` Quotient
----------
-5
(1 row)ssss
```

Previous: DEGREES function
Next: EXP function

﻿