book
Article ID: KB0078026
calendar_today
Updated On:
Description
When converting data using Conversion functions, a null value for a numeric field is converted to:
- TOSTRING — Converted to a NULL (as expected)
- TOBOOLEAN — Converted to FALSE
- TODATETIME — Converted to 01/01/01 00:00:00
- All numeric conversion functions — Converted to a 0 (zero)
Where possible, use the ISNULL function instead.
For additional information, see the following in the TIBCO Scribe® Online Help:
TIBCO Scribe® Online Functions
Issue/Introduction
Results for different functions when converting Null values for a numeric field.