abs

Returns the absolute value of the numeric value x. If the input value is NULL, NULL is returned.

Syntax

ABS(x);

x: the numeric value or expression.

Supported data types: DOUBLE, FLOAT, LARGEINT, BIGINT, INT, SMALLINT, TINYINT, DECIMALV2, DECIMAL32, DECIMAL64, DECIMAL128.

The data type of the return value is the same as the type of x.

mysql> select abs(-1);
+---------+
| abs(-1) |
+---------+
|       1 |
+---------+
1 row in set (0.00 sec)

abs, absolute