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
How to change the TimeStamp Format
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: