ABS()

ABS(X) Returns the absolute value of X, or NULL if X is NULL.

Description

ABS(X) Returns the absolute value of X, or NULL if X is NULL.

Syntax

> ABS(number)

Arguments

Arguments

Description

number

Required. Any numeric data type supported now.

The result type depends on the selected overload; narrower numeric inputs may be widened to the overload’s return type.

Examples

drop table if exists t1;
create table t1(a int,b float);
insert into t1 values(1,-3.1416);
insert into t1 values(-1,1.57);

mysql> select abs(a),abs(b) from t1;
+--------+--------------------+
| abs(a) | abs(b)             |
+--------+--------------------+
|      1 | 3.1415998935699463 |
|      1 | 1.5700000524520874 |
+--------+--------------------+
2 rows in set (0.01 sec)