PostgreSQL CEILING() function

Last update on July 26 2024 12:57:17 (UTC/GMT +8 hours)

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.

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