FLOOR (TSQL Function)
Returns the largest integer less than or equal to, the value of the argument.
Syntax
FLOOR ( numeric_expression )
Arguments
- numeric_expression
- is a numeric expression of type
int
,bigint
,money
,numeric
,float
.
Return Types
Returns the same type as numeric_expression.
Examples
PRINT FLOOR(123), FLOOR(123.45e0), FLOOR($123.45), FLOOR(123.45), FLOOR(-123.45), FLOOR(0.0);
The result is:
123| 123| 123.0000| 123| -124| 0|