CEILING Function in SQL Server(TSQL)

dbtut

5 years ago

The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number as the result. The return data type is the data type of the input parameter.

Below you can see how the CEILING function behaves at different values.

SELECT CEILING(1),
       CEILING(0.34234),
       CEILING(-1),
       CEILING(0.0),
       CEILING(-0.999)

SELECT CEILING(1),

CEILING(0.34234),

CEILING(-1),

CEILING(0.0),

CEILING(-0.999)