Result Type and Attributes

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

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

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.