Search found 18 matches

by samu
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...
by samu
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
by samu
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...