ABS()

Description

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

Syntax

1. > ABS(number)

Arguments

The result type is derived from the argument type.

Examples

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

6. mysql> select abs(a),abs(b) from t1;
7. +--------+--------------------+
8. | abs(a) | abs(b)             |
9. +--------+--------------------+
10. |      1 | 3.1415998935699463 |
11. |      1 | 1.5700000524520874 |
12. +--------+--------------------+
13. 2 rows in set (0.01 sec)