December 5th, 2008
CEILING or CEIL (round upward)
Posted by
admin in
H. ANSI Numeric Scalar Functions
The CEILING function returns the smallest integer greater than the input value.
Format: CEILING(expression)
Example: SELECT CEILING(10.2) FROM TABLEA;
Result:
> DB2 supports CEILING and CEIL.
> MySQL, and SQL Server support only CEILING.
> Oracle supports only CEIL.
> Access, PostgreSQL, and Sybase don’t support CEILING or CEIL.
> CEILING and CEIL are synonymous.
