Collections:
ABS() - Absolute Value
How to calculate the absolute value of a given numeric value using the ABS() function?
✍: FYIcenter.com
ABS(str) is a MySQL built-in function that returns the absolute value of a given value. For example:
SELECT ABS(-18), ABS(-17.7778), ABS(-1.77778E1); -- +----------+---------------+-----------------+ -- | ABS(-18) | ABS(-17.7778) | ABS(-1.77778E1) | -- +----------+---------------+-----------------+ -- | 18 | 17.7778 | 17.7778 | -- +----------+---------------+-----------------+
Reference information of the ABS() function:
ABS(X): val Returns the absolute value of X, or NULL if X is NULL. Arguments, return value and availability: X: Required. The input value. val: Return value. The absolute value of the input value. Available since MySQL 4.0.
⇒ ACOS() - Arccosine Trigonometric Value
⇐ MySQL Functions on Numeric Values
2023-11-15, 246🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
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 Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...