FLOOR (SSIS)

Returns the largest integer that is less than or equal to a numeric expression.

Syntax

FLOOR(numeric_expression)

Arguments

• numeric_expression
  Is a valid numeric expression.

Result Types

The numeric data type of the argument expression. The result is the integer portion of the calculated value in the same data type as numeric_expression.

Remarks

FLOOR returns a null result if the argument is null.

Examples

These examples apply the FLOOR function to positive, negative, and zero values.

FLOOR(123.45)

Returns 123.00

FLOOR(-123.45)

Returns -124.00

FLOOR(0.00)

Returns 0.00

See Also

Reference

CEILING (SSIS)

Other Resources

Functions (SSIS)

Help and Information

Getting SQL Server 2005 Assistance