ABS - Amazon Kinesis Data Analytics SQL Reference
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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