The function CEILING returns the smallest integer for the numeric expression.
SQL Syntax:
|
|
CEILING( number ) |
Number:
|
|
Any numeric expression. |
Escape Syntax:
|
|
{fn CEILING( number )} |
Return Type:
|
|
FLOAT |
|
|
|
Examples:
SELECT CEILING(1.3), {fn ceiling(-0.5)}
see also:
SQL Numeric Functions
ROUND
TRUNCATE
|