FLOOR

Compatibility

FLOOR(f)
Engine	OK	Alternative
ingres	Yes
mysql	Yes
oracle	Yes
postgres	Yes
sqlserver	Yes

FLOOR

FLOOR(f) returns the integer value of f

FLOOR(f) give the integer that is equal to, or just less than f. FLOOR always rounds down.

  FLOOR(2.7) ->  2
  FLOOR(-2.7) -> -3

In this example we calculate the population in millions.

SELECT name,
       FLOOR(population/1000000)
  FROM bbc

See also

• ROUND function
• CEIL function
• MOD function

Language:Project:Language policy	English  • Deutsch