ABS

The ABS function returns the absolute value of the input argument.

Syntax

ABS (argument)

Remarks

The table lists the valid input argument data types and the resulting output data types.

Data Type of Argument	Output Type
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	Same as the input argument.
NULL	NULL
INTERVAL	INTERVAL ABS (- INTERVAL '1' DAY) = INTERVAL '1' DAY

Example

SELECT ABS(-4);

SELECT ABS(4);

The result in either case is 4.