MathTruncate SQL Math Function

The MathTruncate() function takes one (1) argument and returns the integral part of a specified double-precision floating-point number, basically the number that remains after any fractional digits have been discarded in other words rounds the number to the nearest integer towards zero. It requires Double as input and returns value as Double.

Syntax MathTruncate( Number )

		/* Following will return 36 */ 

        SELECT MathTruncate(36.7864);
		


		/* Following will return -36 */ 

        SELECT MathTruncate(-36.7864);