abs()

Scalar. Returns the absolute value of a number.

Syntax

abs ( value )

Parameters

value

An integer, long, money, double, decimal, time, date, timestamp, bigdatetime, or interval.

Usage

The function returns the absolute value of a number. Returns the same datatype as its argument.

Example

abs(13.47) returns 13.47.

abs(-13.47) returns 13.47.