Hi,
I have input column as decimal(38,10) value as e.g "0000000000000000000020070123.0000000000" need to convert into timestamp as "2007-01-23 00:00:00"
What function I can use in transformer to convert from decimal to timestamp. Please provide info.
Regards
Gyani
Search found 1 match
- Mon Jan 29, 2007 6:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal to Timestamp conversion
- Replies: 2
- Views: 1092