Computes the largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression. 

Numeric literal example:


Output: Returns the value 2.

Expression example:

floor(MyValue + 2.5)

Output: Returns the largest integer that is less than the sum of 2.5 and the value in the MyValue column.


ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function


Name of the column, numeric literal, or numeric expression.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal2.5

Example - Exponential functions