Sql Server 2012 Floor Function

It is a numeric value.

Sql server 2012 floor function. The floor function returns the largest integer value which is less than or equal to a number. More specifically it returns the largest integer less than or equal to the specified numeric expression. In sql server the t sql floor function allows you to round a number down to the nearest integer. The return data type is the same as the one provided as an argument.

Select floor 25 75 as floorvalue. The floor function returns the largest integer value that is greater than or equal to the specified numeric expression or we can say that the floor function is an expression of the exact numeric or approximate numeric data type category except for the bit data type. Return the largest integer value that is equal to or less than 25 75. The floor function returns the largest integer value that is smaller than or equal to a number.

It returns the integer value. When the argument holds a positive number. Sql server 2017 sql server 2016 sql server 2014 sql server 2012 sql server 2008 r2 sql server 2008 sql server 2005. Also look at the ceiling and round.

The floor function can be used in the following versions of sql server transact sql. Sql server all supported versions azure sql database azure sql managed instance azure synapse analytics parallel data warehouse returns the largest integer less than or equal to the specified numeric expression. Try it yourself definition and usage. Sql server floor function sql server functions.