The TRUNCATE SQL Function in MySQL and MariaDB - Truncate to decimals
TRUNCATE
Syntax:
TRUNCATE(Number, Decimals)
Return value:
DECIMAL
Function type:
Numeric function
Function Description
The TRUNCATE() function returns a "Number" truncated to "Decimals".
If "Decimals" is 0, an integer is returned.
"Decimals" can be negative so that "Decimal" are digits to the left of the decimal point of the number 0.
TRUNCATE() returns NULL if the value of "Number" is NULL.
Example 1: With a positive number of decimal places.
1 2 3 4
selecttruncate(243.4567,2) as result;
result
decimal(7)
243.45
Example 2: With a negative number of decimal places.
1 2 3 4
selecttruncate(243.4567,-2) as result;
result
decimal(4)
200
Example 3: With a negative number of decimal places.
1 2 3 4
selecttruncate(243.4567,-1) as result;
result
decimal(4)
240
The examples were created with the MyWAY SQL manager: Download
How to use the TRUNCATE() function in MySQL and MariaDB databases
The TRUNCATE() function in MySQL and MariaDB can be used when decimal places of a numeric value should be removed without rounding it. The function is commonly used in financial calculations where precision is required and rounding can lead to incorrect results or inaccuracies.
