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

ArgumentsDescription
numberRequired. Any numeric data type supported now.
decimalsOptional. 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.