Returns expression1 truncated expression2 decimal places.
The first argument (expression1) can be any built-in numeric data type. The second argument (expression2) can be a small or large integer. The absolute value of the second argument specifies the number of decimal places. If the second argument is positive, the first argument is truncated to the right of the decimal point. If the second argument is zero or negative, the first argument is truncated to the left of the decimal point.
Example:
Calculate the average monthly salary for the highest paid employee. Truncate the result to two places to the right of the decimal point.
SELECT TRUNCATE(MAX(SALARY/12, 2) FROM EMP
Because the highest paid employee in the sample employee table earns $52750.00 per year, the example returns the value 4395.83.