Hi All,
I am having problems moving timestamp data from DB2 to Oracle.
For Instance, a typical db2 timestamp value is 2004-03-31-15.01.37.840804
I can not load that value in an oracle timestamp(6), I get a conversion error. Interestingly, I am able to load the value up to the seconds
with zeroes for milliseconds: 2004-03-31-15.01.37.000000. However, I would like to bring the milliseconds too.
Max.
db2 timestamp to oracle timestamp
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Try reformatting your date to the following before passing it to Oracle:
2004-03-31 15:01:37.840
2004-03-31 15:01:37.840
Chuck Smith
www.anotheritco.com
www.anotheritco.com
Hi,
Check with your DBAs for the exact precision the date column have (it might not had miliseconds)
and transform the input date accordingly.
IHTH,
Check with your DBAs for the exact precision the date column have (it might not had miliseconds)
and transform the input date accordingly.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US