Example
Return a number truncated to 2 decimal places:
sql
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.
Syntax
text
TRUNCATE(number, decimals)
Parameter Values
| Parameter | Description |
|---|---|
| number | Required. The number to be truncated |
| decimals | Required. The number of decimal places to truncate to |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return a number truncated to 0 decimal places:
sql
SELECT TRUNCATE(345.156,
0);