Usage Notes - Analytics Database - Teradata Vantage

For all numeric types except FLOAT/REAL/DOUBLE PRECISION, SIGN will return the following:

• If numeric_value is < 0, -1 is returned.
• If numeric_value is = 0, 0 is returned.
• If numeric_value is > 0, 1 is returned.

For FLOAT/REAL/DOUBLE PRECISION, SIGN will return the following:

• If numeric_value is < 0, -1 is returned.
• If numeric_value is >= 0, 1 is returned.

If the input argument is NULL, the function returns NULL.