Result Type and Attributes - Analytics Database - Teradata Vantage

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.