content_image/804178.jpg
<img src='content_image/804178.jpg'>

All mathematical functions return NULL  in the event of an error. 

• ABS( X ) 

Returns the absolute value of X , or NULL  if X  is NULL . 

The result type is derived from the argument type. An implication of this is that ABS(-9223372036854775808)  produces an error because the result cannot be stored in a signed BIGINT  value. 

mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); 

