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