Collections:
TRUNCATE() - Truncating to Decimal Place
How to truncate a value to a given decimal place using the TRUNCATE() function?
✍: FYIcenter.com
TRUNCATE(X, D) is a MySQL built-in function that truncates X to decimal place of D. For example:
SELECT TRUNCATE(-1.58, 0), TRUNCATE(23.298, 1), TRUNCATE(23.298, -1); -- +--------------------+---------------------+----------------------+ -- | TRUNCATE(-1.58, 0) | TRUNCATE(23.298, 1) | TRUNCATE(23.298, -1) | -- +--------------------+---------------------+----------------------+ -- | -1 | 23.2 | 20 | -- +--------------------+---------------------+----------------------+
Reference information of the TRUNCATE() function:
TRUNCATE(X, D): val 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 cause D digits left of the decimal point of the value X to become zero. Arguments, return value and availability: X: Required. The value to be truncated. D: Optional. Default is 0. The decimal place to truncate to. val: Return value. The truncated value. Available since MySQL 4.0.
Related MySQL functions:
⇒ MySQL Functions on Date and Time
⇐ TAN() - Tangent Trigonometric Value
2023-11-14, 349🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...