ABS()

Scalar. Returns the absolute value of an expression.

Syntax

ABS(expression)
Data Types

Return

expression

Integer

Integer

Long

Long

Float

Float

Interval

Interval

Example

The following example calculates the absolute value of a column from the stream named Devices:

INSERT INTO OutStream
SELECT ABS(Devices.Value)
FROM Devices;