Hi
I am trying to load date(along with time)from seqfile to Oracle table.
Source(Seq file) -Timestamp
Target (Oracle table) - Timestamp
I also want the time to be populated in target.
Source
2008-10-14 19:39:09.000
Expected Target
2008-10-14 19:39:09.000
Note :
Oconv(Iconv(Substrings(Extraction_Data.MODIFYDATE,1,10),'D-YMD'),'D-YMD') : Oconv(Iconv(Substrings(Extraction_Data.MODIFYDATE,11,19),'MTS'),'MTS')
works perfectly and I am able to load 2008-10-14 19:39:09 in target
Can anyone let me know how would we populate tthe expected date(along with timestamp) in target.
Thanks
Kiran
Timestamp issue inserting into Oracle table from flat file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't know what you're asking here - you've asked how to do something then described a solution that works. You've also marked the question as relating to a server job yet posted it in the Enterprise Edition forum. This is like asking your greengrocer why your blood pressure is elevated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am