PostgreSQL CEILING() function

CEILING() function

The PostgreSQL ceiling() function is used to return the smallest integer greater than or equal to a given positive or negative decimal value.

Uses of CEILING() Function
• Rounding Up Values: Ensures that any decimal number is rounded up to the nearest integer.

• Financial Calculations: Useful in scenarios where rounding up to the nearest whole number is necessary, such as in pricing or budgeting.

• Data Analysis: Applied in data processing tasks that require ceiling values for accurate aggregations.

• Mathematical Computations: Used in mathematical functions and algorithms where ceiling values are required.

Syntax:

```ceiling()
```

PostgreSQL Version: 9.3

Pictorial presentation of PostgreSQL CEILING() function

Example: PostgreSQL CEILING() function

Code:

``````SELECT CEILING(69.4) AS "Ceiling";
```
```

Sample Output:

``` Ceiling
---------
70
(1 row)
```

Example: PostgreSQL CEILING() function using negative value

Code:

``````SELECT CEILING(-69.8) AS "Ceiling";
```
```

Sample Output:

``` Ceiling
---------
-69
(1 row)
```

Previous: CEIL function
Next: COS function

﻿

Follow us on Facebook and Twitter for latest update.