Skip to main content
Version: Stable-3.1

negative

Description

Returns the negative of input arg.

Syntax

negative(arg)

Parameter

arg supports the following data types:

  • BIGINT
  • DOUBLE
  • DECIMALV2
  • DECIMAL32
  • DECIMAL64
  • DECIMAL128

Return value

Returns a value of the same data type as the input.

Examples

mysql> select negative(3);
+-------------+
| negative(3) |
+-------------+
| -3 |
+-------------+
1 row in set (0.00 sec)

mysql> select negative(cast(3.14 as decimalv2));
+--------------------------------------+
| negative(CAST(3.14 AS DECIMAL(9,0))) |
+--------------------------------------+
| -3.14 |
+--------------------------------------+
1 row in set (0.01 sec)