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

This function returns a BIGINT datatype.

FLOOR( numeric_expression )

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

> 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

See also: