ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

CEILING function [Numeric]

Example