MSSQL›Numeric Functions›FLOOR
←CEILING

FLOORNumeric Functions

ROUND→

Returns the floor.

Syntax

FLOOR(n)

Example

Enter values below to update the example in real time.

floor_val→
SELECT FLOOR(3.9) AS floor_val;