source timestamp to target timestamp using iconv,oconv
Posted: Wed Nov 17, 2010 3:10 am
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
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