Syntax

 

<absolute value expression> ::=

 

 

 

ABS ( <numeric value expression> )

 

 

Notes

 

The ABS function returns the unsigned value of the argument.



 

The data type of the result is the same type as the argument.



 

If the argument is null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

ABS( 5 )

5

ABS( -5.25 )

5.25

 

 


 

Conformance

 

SQL:2003 standard

-

Feature T441 "ABS and MOD functions"