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, 337🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...