Category: ASE: Functions: Mathematical Functions

ceiling()

The Mathematical Function ceiling() returns a rounded number, which is greater or equal to the given parameter "number".

Syntax of the Mathematical Function ceiling()

    ceiling(number)

The parameter "number" of the Mathematical Function ceiling()

number
The parameter "number" is a placeholder for column names, variables or "expressions", that have to be of one of the following datatypes: exact numeric, approximate numeric, money. Additionally, the parameter "number" recognises every other datatype which can be converted into one of the required datatypes using implicit conversion.

Example for the Mathematical Function ceiling()

    select ceiling(124.35)

    go

    -----

    125

Returns 125.

    select ceiling(124.78)

    go

    -----

    125

Returns 125.

    select ceiling(-124.35)

    go

    -----

    -124

Returns -124.

    select ceiling(-124.78)

    go

    -----

    -124

Returns -124.

    select ceiling($124.78)

    go

    -----

    125.00

Returns 125.00.

ASE T-SQL - Aggregate Functions,
Mathematical Functions,
abs(),
acos(),
asin(),
atan(),
atn2(),
cos(),
cot(),
degrees(),
exp(),
floor(),
log(),
log10(),
pi(),
power(),
radians(),
rand(),
round(),
sign(),
sin(),
sqrt(),
tan().