CEIL
Returns a number rounded up to the nearest integer.
PostgreSQL 17.9
CEIL(num)- num
- Number to roundnumeric | double precision
Return value
A whole value: numeric for numeric, double precision for double precision and for an integer argument
Examples
Positive fraction
PostgreSQL 17.9
SELECT CEIL(0.2);Negative fraction
PostgreSQL 17.9
SELECT CEIL(-0.2);Whole number
PostgreSQL 17.9
SELECT CEIL(3);Details
CEILING is a synonym for CEIL.
Negative numbers are rounded towards zero: CEIL(-1.2) returns -1.