ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the floor of (largest integer not greater than) a number.
FLOOR ( numeric-expression )
numeric- expression The number, usually a float.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
Value | FLOOR (Value) |
---|---|
123 | 123 |
123.45 | 123 |
-123.45 | -124 |