ABS

 

The function ABS returns the absolute, positive value of a given numeric expression.

SQL Syntax:
 
   ABS( number )
Number:
 
  Any numeric expression
Escape Syntax:
 
  {fn ABS( number )}
Return Type:
 
  The same as the numeric expression.
     

Examples:

  • SELECT abs(1.0), {fn abs(-2.3)}

see also:
SQL Numeric Functions


100% pure Java DBMS
Mirror Site