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

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);