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|
RSQL, a simple alternative to Microsoft SQL Server