FLOOR()

Description

The FLOOR() function returns the largest round number that is less than or equal to the number.

Syntax

1. > FLOOR(number, decimals)
2. > FLOOR(number)

Arguments

Arguments Description
number Required. Any numeric data type supported now.
decimals Optional. An integer that represents the number of decimal places. By default it is zero, which means to round to an integer. decimals may also be negative.

Examples

1. floor(12, -1) ----> 10
2. floor(12) ----> 12
3. floor(-12, -1) ----> -20
4. floor(-12, 1) ----> -12
5. floor(12.345) ----> 12
6. floor(12.345, 1) ----> 12.3
7. floor(-12.345, 1) ----> -12.4
8. floor(-12.345, -1) ----> -20
9. floor(-12.345) ----> -13

Constraints

Currently, MatrixOne doesn’t support select function() without from tables.