PostgreSQL CEIL() function

CEIL() function

The PostgreSQL ceil() function is used to return the value, after rounded up any positive or negative decimal value as greater than the argument.

Syntax:

ceil()

PostgreSQL Version: 9.3

Pictorial presentation of PostgreSQL CEIL() function

Example: PostgreSQL CEIL() function

Code:

SELECT CEIL(53.7) AS "Ceil";

Sample Output:

 Ceil
------
   54
(1 row)

Example: PostgreSQL CEIL() function with negative value

Code:

SELECT CEIL(-53.7) AS "Ceil";

Sample Output:

 Ceil
------
  -53
(1 row)

Previous: CBRT function
Next: CEILING function