16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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.