How to change the TimeStamp Format
Posted: Wed Mar 23, 2011 12:58 pm
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
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