TRUNCATE

Use the TRUNCATE function to truncate a numeric value to the specified number of decimal places.

Syntax

TRUNCATE(number_value, number_of_decimal_places)