FLOOR() and CEILING() Function in SQL Server

1. FLOOR() Function :
The FLOOR() function returns the largest integer value which is less than or equal to a number.

Syntax :

FLOOR(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the integer value.

Example-1 :
When the argument holds a positive number.

SELECT FLOOR(21.53);

Output :

21

Example-2 :
When the argument holds a negative number.

SELECT FLOOR(-21.53);

Output :

-22

2. CEILING() Function :
The CEILING() function returns the smallest integer value which is greater than or equal to a number.

Syntax :

CEILING(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the integer value.

Example-1 :
When the argument holds a positive number.

SELECT CEILING(21.53);

Output :

22

Example-2 :
When the argument holds a negative number.

SELECT CEILING(-21.53);

Output :

-21