FLOOR

Syntax

FLOOR(X)

Description

Returns the largest integer value not greater than X.

Examples

SELECT FLOOR(1.23); +-------------+ | FLOOR(1.23) | +-------------+ | 1 | +-------------+  SELECT FLOOR(-1.23); +--------------+ | FLOOR(-1.23) | +--------------+ | -2 | +--------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}