Returns the value of an expression.
Syntax
TINYINT|SMALLINT|INT|BIGINT|DOUBLE|DECIMAL positive(TINYINT|SMALLINT|INT|BIGINT|DOUBLE|DECIMAL <expr>)Parameters
expr: Required. The input expression. The value can be of the TINYINT, SMALLINT, INT, BIGINT, DOUBLE, or DECIMAL type.
Return value
Returns the value of the expr expression.
Examples
--The return value is 1.
SELECT positive(1);Related functions
POSITIVE is a mathematical function. For more information about functions related to data computing and conversion, see Mathematical Functions Overview.