Using Conversion Functions In A Formula To Convert A Null Value For A Numeric Field

Using Conversion Functions In A Formula To Convert A Null Value For A Numeric Field

book

Article ID: KB0078026

calendar_today

Updated On:

Products Versions
TIBCO Scribe Online -

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.
Powered by Wolken Software