17.10 - Result Type and Attributes - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Here are the default attributes for the result of ZEROIFNULL.

  • If the operand is numeric, the format is the same format as arg.
  • If the operand is character, the format is the default format for FLOAT.
  • If the operand is a UDT, the format is the format of the predefined type to which the UDT is implicitly cast.
The NULL keyword has a data type of INTEGER.