I have source as timestamp i.e 'YYYY-MM-DD HH24:MI:SS' and I need to load into Oracle target table as timestamp.
I have used oconv and iconv functions
Oconv(Iconv(MODIFYDATE,'D-YMD','D-YMD')
when input is '2010-11-16 14:24:36'
The above gives me output as '2010-11-16 00:00:00' .
Is there any way so that I can capture the exact '2010-11-16 14:24:36' also in the target instead '2010-11-16 00:00:00'
Thanks
Kiran
source timestamp to target timestamp using iconv,oconv
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:
Welcome aboard. My initial thought is that you don't need to do anything - the source is already in the correct format for Oracle.
If you are going to use Oconv() and Iconv() you need first to segregate the date and time portions, perhaps using Field() functions or substrings.
If you are going to use Oconv() and Iconv() you need first to segregate the date and time portions, perhaps using Field() functions or substrings.
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