16.20 - Examples - 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

Example 1: Query SELECT SIGN(-2);

The following query returns the result -1.

   SELECT SIGN(-2);

Example 2: Query Results When the Value is an Integer and Equal to 0

The following query returns the result 0 since the value is an integer and equal to 0.

   SELECT SIGN(CAST(0 AS INTEGER));

Example 3: Query Results When the data type is FLOAT and the value is >= 0

The following query returns the result 1 since the data type is FLOAT and the value is >= 0.

   SELECT SIGN(CAST(0 as FLOAT));

Example 4: Query SELECT SIGN(3.74);

The following query returns the result 1.

   SELECT SIGN(3.74);