ceiling

Description

Returns the smallest integer greater than or equal to the specified value.

Syntax

ceiling(value)

Parameters

value

is a column, variable, or expression with a datatype is exact numeric, approximate numeric, money, or any type that can be implicitly converted to one of these types.

Examples

Example 1

select ceiling(123.45)

124 

Example 2

select ceiling(-123.45)

-123 

Example 3

select ceiling(1.2345E2)

24.000000

Example 4

select ceiling(-1.2345E2)

-123.000000

Example 5

select ceiling($123.45)

124.00 

Example 6

select discount, ceiling(discount) from salesdetail where title_id = "PS3333"

discount                                  
 -------------------- -------------------- 
            45.000000            45.000000 
            46.700000            47.000000 
            46.700000            47.000000 
            50.000000            50.000000 

Usage

• ceiling, a mathematical function, returns the smallest integer that is greater than or equal to the specified value. The return value has the same datatype as the value supplied.

  For numeric and decimal values, results have the same precision as the value supplied and a scale of zero.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute ceiling.

See also

For general information about mathematical functions, see “Mathematical functions”.

Command set

Functions abs, floor, round, sign

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF