Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ Mathematical Functions/ negative
Updated on 2023-10-25 GMT+08:00
View PDF

negative

This function is used to return the additive inverse of a.

Syntax

negative(INT a)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

The value can be a float, integer, or string.

Return Values

The return value is of the DECIMAL or INT type.

If the value of a is NULL, NULL is returned.

Example Code

The value -1 is returned.

SELECT negative(1);

The value 3 is returned.

SELECT negative(-3);
Parent topic: Mathematical Functions