positive¶
This function is used to return the value of a.
Syntax¶
positive(INT a)
Parameters¶
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.
Note
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');