SQL Anywhere 10.0.1
**» **SQL Anywhere Server - SQL Reference
**» **SQL Functions
**» **Alphabetical list of functions

### CEILING function [Numeric]

Returns the ceiling of a number.

######
Syntax

**CEILING(** *numeric-expression* **)**

######
Parameters

**numeric-expression** The number whose ceiling is to be calculated.

######
Remarks

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.

######
See also

######
Standards and compatibility

######
Example

The following statement returns the value 60.

SELECT CEILING( 59.84567 );