Reference Guide > TDV Support for SQL Functions > Numeric Functions > ABS
 
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.