How to change the TimeStamp Format

[chandra.shekhar@tcs.com]

Hi,
The TIMESTAMP format is showing like %yyyy-%mm-%dd %hh:%nn:%ss in default format tab of Job properties window for parallel job.

My source timestamp format is yyyy-mm-dd hh:mm:ss:sssssss (example : 2011-03-23 23:12:12:123456 ) and I want to load the same into target.
But when I am trying to load, it is rounding the Micro Seconds part (example 2011-03-23 23:12:12:000000).

I changed the Timestamp format to
%yyyy-%mm-%dd %hh:%nn:%ss:%ssssss in job properties but not achieved the desired output.
Could anyone please provide the solution

Thanks & Regards
Srinivas Tanneeru

[ray.wurlod]

%ss.6