DSXchange

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 .

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 .