MySQL TRUNCATE() Function

Return a number truncated to 2 decimal places:

SELECT TRUNCATE(135.375, 2);

Definition and Usage

The TRUNCATE() function truncates a number to the specified number of decimal places.

Note: See also the FLOOR(), CEIL(), CEILING(), and ROUND() functions.

TRUNCATE(number, decimals)

Parameter	Description
number	Required. The number to be truncated
decimals	Required. The number of decimal places to truncate to

Works in:	From MySQL 4.0

Return a number truncated to 0 decimal places:

SELECT TRUNCATE(345.156, 0);