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)