floor

Returns the largest integer that is less than or equal to the specified value.

Syntax

floor(numeric)

Parameters

Examples

Usage

For numeric and decimal expressions, the results have a precision equal to that of the expression and a scale of 0.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute floor.

Related reference
abs
ceiling
round
sign