Search found 18 matches
- Thu Dec 15, 2005 10:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 11
- Views: 5883
Re: Date Conversion
thanks, it worked Hi Samu could u give the function u used to get the date format n how did u eliminate the 1 from the date given in flat file thanks in advance. RK Hi ravij, I didn't use any function to get my date format., simply i implemented exactly what kcdland suggested ie., simply add 19 for...
- Tue Dec 13, 2005 2:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 11
- Views: 5883
Re: Date Conversion
thanks, it worked
- Mon Dec 12, 2005 2:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 11
- Views: 5883
Date Conversion
My source data is a flat file in which i am getting date column as 'CYYMMDD' where C = 1 or 0 which represents 2000 and 1900 centuries, YY - year, MM - month and DD - date. For example: source column is in the format '1050713', target should be in this format ' July 13, 2005'. Any advice of how to d...