Returns numeric_exp truncated to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is truncated to |integer_exp| places to the left of the decimal point.

 

Example:

SELECT TRUNCATE(-75.123456, 3) returns -75.123