TRUNCATE()¶
Returns the input number truncated to the specified number of decimal places without rounding. Unlike
ROUND(),TRUNCATE()simply drops the extra fractional digits.
Description¶
The TRUNCATE() function returns the number X truncated to D decimal places. If D is 0, the result has no decimal point or fractional part. D can be negative to truncate (make zero) D digits left of the decimal point. Unlike ROUND(), TRUNCATE() does not perform any rounding.
Syntax¶
> TRUNCATE(X, D)
Arguments¶
Arguments |
Description |
|---|---|
X |
Required. The number to truncate. |
D |
Required. The number of decimal places to keep. |
Examples¶
DROP DATABASE IF EXISTS truncate_tests;
CREATE DATABASE truncate_tests;
USE truncate_tests;
CREATE TABLE t1(a DOUBLE, b INT);
INSERT INTO t1 VALUES (4.567, 2), (4.567, 0), (-4.567, 2), (10.123456, 3), (-10.123456, 3);
SELECT a, b, TRUNCATE(a, b) AS truncated FROM t1;
DROP DATABASE truncate_tests;