Floor Function

Wed, 03/04/2009 - 20:02 |  hdanzl


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"
‹ Square Root FunctionupCeiling Function ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Functions | Numeric Value Functions

Powered by Drupal and Drupal Theme created with Artisteer.