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, 244🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...