ABS function - Amazon Redshift

ABS function

ABS calculates the absolute value of a number, where that number can be a literal or an expression that evaluates to a number.

Syntax

ABS(number)

Arguments

number

Number or expression that evaluates to a number. It can be the SMALLINT, INTEGER, BIGINT, DECIMAL, FLOAT4, FLOAT8, or SUPER type.

Return type

ABS returns the same data type as its argument.

Examples

To calculate the absolute value of -38, use the following example.

SELECT ABS(-38); +-----+ | abs | +-----+ | 38 | +-----+

To calculate the absolute value of (14-76), use the following example.

SELECT ABS(14-76); +-----+ | abs | +-----+ | 62 | +-----+