Skip to Content
Former Member
Jul 21, 2010 at 02:59 AM

Date type convertion changed from 11.5 to 12.2



Customer is migrating from 11.5 to 12.2. They found the bahvior changes according to the 'MigrationBehaviorChanges.pdf'.

Conversion between different data types

For this release, there is a change in behavior for data conversion between

different data types. Previously, if an error occurred during data conversion

(for example when converting a varchar string to an integer, the varchar string

contains non-digits), the result was random. Now, the return value will be

NULL for any unsuccessful conversion.

Previously Data Integrator returned random data for the result of a varchar to

datetime conversion when the varchar string contains an illegal date format.

Now, the return value will be NULL.

May I know anyway that we can set DS12.2 to funciton same as 11.5 in the data type conversion?

thanks and regards