Load DATE type into an Oracle TIMESTAMP column

[Anonymous]

Hi,
I need to load a DATE field with millisecond ("yyyy-MM-dd HH:mm:ss.zzz") into an oracle table.
but unfortunately, oracle needs TIMESTAMP datatype in order to manage the milliseconds.
When I run my job, I receive the following exception:
"ORA-01858: a non-numeric character was found where a numeric was expected"
How to match the talend DATE with oracle TIMESTAMP?
Thanks in advance,
Regards,
michelangelo

[_AnonymousUser]

I am using Talend DI 6.2.1.
Database :- Oracle 12c
Input is 
select TO_TIMESTAMP ((TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MIS.FF')), 'YYYY-MM-DD HH24:MIS.FF')as LOAD_DATETIME from dual
and want to store output in Oracle table with tOracle output.
However Talend is not able to load milisecond part of the input. 
On tLogRow it shows with millisecond part however on target table it is not displaying miliseconds.
Is the bug previously mentioned for version 5.4 is still present in 6.2.1?

Hi Amit,
    Did you find any resolution?
    I too find the same issue in 6.2.1.
Regards,
HarishBabu D

[vapukov]

I am using Talend DI 6.2.1.
Database :- Oracle 12c
Input is 
select TO_TIMESTAMP ((TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MIS.FF')), 'YYYY-MM-DD HH24:MIS.FF')as LOAD_DATETIME from dual
and want to store output in Oracle table with tOracle output.
However Talend is not able to load milisecond part of the input. 
On tLogRow it shows with millisecond part however on target table it is not displaying miliseconds.
Is the bug previously mentioned for version 5.4 is still present in 6.2.1?

Hi Amit,
    Did you find any resolution?
    I too find the same issue in 6.2.1.
Regards,
HarishBabu D
there are no any issue, Oracle date - not support milliseconds 
if You want store milliseconds - use TIMESTAMP datatype for oracle columns
proper format for convert string to timestamp - 

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.SSS",row1.dateColumn)