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.
Rounds the expression down to the nearest integer.
FLOOR(numeric_expression)
FLOOR(1.3)
returns 1
FLOOR(1.5)
returns 1
Double
If input is null, returns null.
Free 7-day trial. Easy setup. Cancel any time