NexusDB V3 Manual
Floor Function
|
|
NexusDB Manual V3 > SQL Reference > SQL Functions > Numeric Value Functions
|
Syntax
<floor function> ::=
Notes
§
|
The FLOOR function returns the greatest whole number (scale 0) that is less than or equal to the argument.
|
§
|
The data type of the result is the same type as the argument.
|
§
|
If the argument is null, then the result is null.
|
Examples
Expression
|
Result
|
FLOOR( 5 )
|
5
|
FLOOR( 5.25 )
|
5
|
FLOOR( -5.25 )
|
-6
|
Conformance
SQL:2003 standard
|
-
|
Feature T621 "Enhanced numeric functions"
|
|
© Nexus Database Systems Pty Ltd.