Omnidex SQL Function: FLOOR

Description

Rounds a non-integer value downward to the next lower integer.

This function returns a BIGINT datatype.

Syntax

FLOOR( numeric_expression )
numeric_expression

Required. Any expression that returns a numeric-class datatype.

Example

Example 1: Column

> select latitude, floor(latitude) floor_lat from countries;

LATITUDE                          FLOOR_LAT
--------------------------------  ----------------------
                       42.500000                      42
                       24.000000                      24
                       33.000000                      33
                       17.049999                      17
                       18.209999                      18
                       41.000000                      41
                       40.000000                      40

Additional Resources

See also:

 
Back to top
dev/sql/functions/floor.txt ยท Last modified: 2016/06/28 22:38 (external edit)