Help Center> Data Lake Insight> SQL Syntax Reference (To Be Offline)> Spark SQL Syntax Reference (Unavailable Soon)> Built-in Functions> Mathematical Functions> positive
Updated on 2023-10-25 GMT+08:00
View PDF

positive

This function is used to return the value of a.

Syntax

positive(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, DOUBLE, or INT type.

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

Example Code

The value 3 is returned.

SELECT positive(3);

The value -3 is returned.

SELECT positive(-3);

The value 123 is returned.

SELECT positive('123');
Parent topic: Mathematical Functions