16.20 - Usage Notes - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.