PostgreSQL›Numeric Functions›FLOOR
←CEIL

FLOORNumeric Functions

ROUND→

Returns the floor (largest integer not greater than x).

Syntax

FLOOR(x)

Example

Enter values below to update the example in real time.

salary→
salary_band→
employees→
SELECT FLOOR(salary / 1000.0) * 1000 AS salary_band
FROM employees;