SqlExpression FLOOR

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

FLOOR( numeric_expression )

Purpose

Returns the largest integer less 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
FLOOR( 2.5e0 )	2
FLOOR( cast(-1.2e0 as REAL) )	-2
FLOOR( 1.7 )	1
FLOOR( -1.7 )	-2

---

Return to Built in Function details