FLOOR

Description

Rounds the expression down to the nearest integer.

Syntax

FLOOR(numeric_expression)

Examples

FLOOR(1.3) returns 1

FLOOR(1.5) returns 1

Return value datatype

Double

Impact of null value

If input is null, returns null.