Search found 2 matches

by roopkumar
Tue Nov 29, 2011 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help on Datatype Conversion
Replies: 7
Views: 3296

Hi Chulett,

Thanks for the reply. Can you please let me know how you converted this hexidecimal to Date Data type. Means which Transformer function you used to covert this ?

Thanks In Advance.

Rgds,
RooP KumaR.
by roopkumar
Tue Nov 29, 2011 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help on Datatype Conversion
Replies: 7
Views: 3296

Need help on Datatype Conversion

Hi All, I have a requirement that i have to convert from varbinary format to Date format. The derivation for the fields is Start date = SUBSTR(<Source field value>, 1,10) and End date = SUBSTR(<Source field value>, 12,10) and both should be loaded in format MM/DD/YYYY. But the sample values for varb...