SqlExpression CEIL

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

CEIL( numeric_expression )

Purpose

Returns the smallest integer greater than or equal to a numeric expression

Input

• numeric_expression - source numeric expression

Output

• returns the same datatype as input, but with scale 0 if datatype contains scale. Returns null on null input

Example

Function	Result
CEIL( 10.1e0 )	11
CEIL( -11.2e0 )	-11
CEIL( 100 )	100
CEIL( 1.3 )	2
CEIL( -1.7 )	-1

---

Return to Built in Function details