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.
Search found 2 matches
- 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
- 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...