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 Cloud Integration - Connect ( Scribe )	-

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.

Feedback

thumb_up Yes

thumb_down No