SQL Reference

ABS or ABSVAL

>>-+-ABS----+--(--expression--)--------------------------------><
   '-ABSVAL-'
 

The schema is SYSFUN.

Returns the absolute value of the argument.

The argument can be of any built-in numeric data type. If it is of type DECIMAL or REAL, it is converted to a double-precision floating-point number for processing by the function.

The result of the function is:

• SMALLINT if the argument is SMALLINT
• INTEGER if the argument is INTEGER
• BIGINT if the argument is BIGINT
• DOUBLE if the argument is DOUBLE, DECIMAL or REAL ³⁹ .

The result can be null; if the argument is null, the result is the null value.

³⁹

Also returns DOUBLE when the argument is the smallest value of BIGINT, -9 223 372 036 854 775 808.