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 value is an expression of the TINYINT, SMALLINT, INT, BIGINT, DOUBLE, or DECIMAL type.
Return value
The value of expr is returned.
Examples
-- The value 1 is returned.
SELECT positive(1);Related functions
POSITIVE is a mathematical function. For more information about functions related to data computing and conversion, see Mathematical functions.