:orphan:

.. _floor:

**************************
FLOOR
**************************

Calculates the largest integer smaller or equal to the numeric expression given.

See also :ref:`round`, :ref:`ceiling`.

Syntax
==========

.. code-block:: postgres

   FLOOR ( expr )

Arguments
============

.. list-table:: 
   :widths: auto
   :header-rows: 1
   
   * - Parameter
     - Description
   * - ``expr``
     - Numeric expression

Returns
============

Returns the same type as the argument supplied.

When using the ``FLOOR`` floating point number scalar function, ``real`` arguments are automatically cast to ``double`` precision.

Notes
=======

* If the input value is NULL, the result is NULL.

Examples
===========

``FLOOR`` vs. :ref:`ceiling` vs. :ref:`round`
------------------------------------------------------------

.. code-block:: psql

   numbers=> SELECT FLOOR(x), CEIL(x), ROUND(x) 
   .      FROM (VALUES (0.0001), (-0.0001)
   .           , (PI()), (-2.718281), (500.1234)) as t(x);
   floor | ceil | round
   ------+------+------
       0 |    1 |    -0
       3 |    4 |     3
      -3 |   -2 |    -3
     500 |  501 |   500