MathFloor SQL Math Function

The MathFloor() function takes one (1) argument and returns the largest integer less than or equal to the specified double-precision floating-point number, this kind of rounding is sometimes called rounding toward negative infinity. If number argument is negative, the presence of any fractional component causes it to be rounded to the smaller integer If numbers are out of Double range which is set in .NET, it will return "Infinity".

Syntax MathFloor( Number )

		/* Following will return 4 */ 

        SELECT MathFloor(4.51);
		


		/* Following will return 0 */ 

        SELECT MathFloor(0.15);
		


		/* Following will return -1 */ 

        SELECT MathFloor(-0.15);
		


		/* Following will return -8 */ 

        SELECT MathFloor(-7.1);