ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

CEILING function [Numeric]

Function 

• Returns the ceiling (smallest integer not less than) of a number.

Syntax 

CEILING ( numeric-expression )

Parameters 

numeric expression    The number whose ceiling is to be calculated.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

FLOOR function [Numeric]

Example 

The following statement returns the value 60.

SELECT CEILING( 59.84567 )