TRUNCATE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns a number truncated to the requested decimal places.
EXAMPLES
SELECT TRUNCATE(1.555,0), TRUNCATE(-1.555,1);
+-------------------+--------------------+
| TRUNCATE(1.555,0) | TRUNCATE(-1.555,1) |
+-------------------+--------------------+
| 1 | -1.5 |
+-------------------+--------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.