Menu
Amazon Kinesis Data Analytics
SQL Reference

ABS

Returns the absolute value of the input argument. Returns null if the input argument is null.

ABS ( <numeric-expression>  <interval-expression> )

Examples

Function Result

ABS(2.0)

2.0

ABS(-1.0)

1.0

ABS(0)

0

ABS(-3 * 3)

9

ABS(INTERVAL '-3 4:20' DAY TO MINUTE)

INTERVAL '3 4:20' DAY TO MINUTE

If you use cast as VARCHAR in SQLline to show the output, the value is returned as +3 04:20.

values(cast(ABS(INTERVAL '-3 4:20' DAY TO MINUTE) AS VARCHAR(8)));  +-----------+    EXPR$0    +-----------+   +3 04:20    +-----------+  1 row selected

On this page: