Navigation:  NexusDB Guide > SQL Reference > SQL Functions > Numeric Value Functions >

Floor Function

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Floor Function

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Functions > Numeric Value Functions

Syntax

 

<floor function> ::=

 

 

 

FLOOR ( <numeric value expression> )

 

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.

nexus_logo