FLOOR function [Numeric]

Function

Returns the floor of (largest integer not greater than) a number.

Syntax

FLOOR ( numeric-expression )

Parameters

numeric-expression The number, usually a float.

Examples

The following statement returns the value 123.00:

SELECT FLOOR ( 123 ) FROM iq_dummy

The following statement returns the value 123:

SELECT FLOOR ( 123.45 ) FROM iq_dummy

The following statement returns the value -124.00.

SELECT FLOOR ( -123.45 ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension

Sybase Compatible with Adaptive Server Enterprise

See also

“CEILING function [Numeric]”