Data format needs to change

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sourav
Participant
Posts: 17
Joined: Tue Sep 04, 2007 5:34 pm
Location: Delhi

Data format needs to change

Post by Sourav »

Hi ,

I have a record like
1/14/2009 1:09:50 PM and 1/14/2009 1:09:50 AM and i am getting this record from the source level.so i want to convert this record like as below mentioned

2009-01-14 13:09:50 [ 1/14/2009 1:09:50 PM ]
2009-01-14 1:09:50

Kindly help me .
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

Hi ,
You can acheive this in a sequential file format .In that format tab , mention the timestamp format according to the requirement and read it as timestamp .
Nag
Post Reply