When called with a numeric argument, CEILING returns the smallest integer equal to or larger than the input argument. When called with a date, time, or timestamp expression, CEILING returns the smallest value equal to or larger than the input, subject to the precision specified by the .
CEIL | CEILING ( < - number-expression> )
CEIL | CEILING ( < - datetime-expression> TO < - time-unit> )
CEIL | CEILING ( <number-expression> )
CEIL | CEILING ( <datetime-expression> TO <[[time-unit> )
Returns null if any input argument is null.
Function | Result |
---|---|
CEIL(2.0) | 2 |
CEIL(-1.0) | -1 |
CEIL(5.4) | 6 |
CEILING(-3.3) | -3 |
CEILING(-3 * 3.1) | -9 |
CEILING(TIMESTAMP ‘2004-09-30 13:48:23’ TO HOUR) | TIMESTAMP ‘2004-09-30 14:00:00’ |
CEILING(TIMESTAMP ‘2004-09-30 13:48:23’ TO MINUTE) | TIMESTAMP ‘2004-09-30 13:49:00’ |
CEILING(TIMESTAMP ‘2004-09-30 13:48:23’ TO DAY) | TIMESTAMP ‘2004-10-01 00:00:00.0’ |
CEILING(TIMESTAMP ‘2004-09-30 13:48:23’ TO YEAR) | TIMESTAMP ‘2005-01-01 00:00:00.0’ |