Returns the ceiling of a number.
CEILING( numeric-expression )
numeric-expression The number whose ceiling is to be calculated.
The CEILING function returns the first integer that is greater or equal to a given value. For positive numbers, this is also known as rounding up.
This function converts its argument to DOUBLE, performs the computation in double-precision floating point, and returns a DOUBLE as the result.
SQL/2003 Vendor extension.
The following statement returns the value 60.
SELECT CEILING( 59.84567 );
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|