ABS

Description

Returns the absolute value of x

Syntax

ABS(<x>) 

Parameters

Parameter	Description
<x>	The value for which the absolute value is to be calculated

Return Value

The absolute value of parameter x. When x is NULL, returns NULL.

Example

select abs(-2);

+---------+
| abs(-2) |
+---------+
|       2 |
+---------+

select abs(3.254655654);

+------------------+
| abs(3.254655654) |
+------------------+
|      3.254655654 |
+------------------+

select abs(-3254654236547654354654767);

+---------------------------------+
| abs(-3254654236547654354654767) |
+---------------------------------+
| 3254654236547654354654767       |
+---------------------------------+

select abs(NULL);

+-----------+
| abs(NULL) |
+-----------+
|      NULL |
+-----------+