MySQL: TRUNCATE Function
This MySQL tutorial explains how to use the MySQL TRUNCATE function with syntax and examples.
Description
The MySQL TRUNCATE function returns a number truncated to a certain number of decimal places.
Syntax
The syntax for the TRUNCATE function in MySQL is:
TRUNCATE( number, decimal_places )
Parameters or Arguments
- number
- The number to truncate.
- decimal_places
- The number of decimal places truncate to. This value must be a positive or negative integer.
Note
Applies To
The TRUNCATE function can be used in the following versions of MySQL:
- MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23
Example
Let's look at some MySQL TRUNCATE function examples and explore how to use the TRUNCATE function in MySQL.
For example:
mysql> SELECT TRUNCATE(125.315, 0); Result: 125 mysql> SELECT TRUNCATE(125.315, 1); Result: 125.3 mysql> SELECT TRUNCATE(125.315, 2); Result: 125.31 mysql> SELECT TRUNCATE(125.315, -1); Result: 120 mysql> SELECT TRUNCATE(125.315, -2); Result: 100 mysql> SELECT TRUNCATE(-125.315, 0); Result: -125
Advertisements