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.