ABS

​

Syntax

​

Scalar

abs(value)

​

Arguments

​

Returns

• Type: Same SQL type as value
• Possible values: The nonnegative magnitude; NaN remains NaN.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

​

Usage notes

• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.
• A DECIMAL result keeps its precision and scale as described above. Depending on decimal settings, query tools may report DOUBLE instead; this does not convert the returned value.

​

Examples

​

Value and NULL input

SELECT abs(-5) AS "value", abs(CAST(NULL AS INT)) AS null_value;

​

Integer and decimal inputs

WITH sample AS (
  SELECT id, CASE WHEN id = 0 THEN CAST(-7 AS BIGINT) ELSE CAST(8 AS BIGINT) END AS i,
    CASE WHEN id = 0 THEN CAST(-7.25 AS DECIMAL(8,2)) ELSE CAST(8.50 AS DECIMAL(8,2)) END AS d
  FROM range(0, 2)
)
SELECT abs(i) AS integer_value, abs(d) AS decimal_value FROM sample ORDER BY id;

​

Limitations

• The minimum signed value of TINYINT, SMALLINT, INT or BIGINT cannot be made positive in the same type and raises an overflow error.
• ABS supports numeric inputs. INTERVAL input is not supported.