Collections:
ROUND() - Rounding to Decimal Place
How to round a value to a given decimal place using the ROUND() function?
✍: FYIcenter.com
ROUND(X, D) is a MySQL built-in function that rounds X to decimal place of D. For example:
SELECT ROUND(-1.58), ROUND(23.298, 1), ROUND(23.298, -1); -- +--------------+------------------+-------------------+ -- | ROUND(-1.58) | ROUND(23.298, 1) | ROUND(23.298, -1) | -- +--------------+------------------+-------------------+ -- | -2 | 23.3 | 20 | -- +--------------+------------------+-------------------+
Reference information of the ROUND() function:
ROUND(X, D): val Rounds the argument X to D decimal places. 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 rounded. D: Optional. Default is 0. The decimal place to round to. val: Return value. The rounded value. Available since MySQL 4.0.
Related MySQL functions:
⇐ RAND() - Random Value Generator
2023-11-15, 262🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...