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

[Anonymous]

Hi,
The issue has been resolved in talend version 5.0.4, 5.1.4, 5.2.2, 5.3.0M3. Fortunately, the version of 5.2.2 will be released in the two days. Please wait for that.
Best regards
Sabrina

[Anonymous]

Thank you so much for your support Sabrina!
I'll wait for 5.2.2.
Regards,
michelangelo

[Anonymous]

Hi michelangelo,
If the talend open studio version of 5.2.2 is available, I will inform you in forum at the first time. Please pay attention about talend forum, thanks.
Best regards
Sabrina

[Anonymous]

Hi mpagano,
Here is a good news that Talend open studio version of 5.2.2 is available now.
Please see this announcement forum for details Forum28549
Best regards
Sabrina

[Anonymous]

Thank you Sabrina!
Best Regards,
michelangelo

[Anonymous]

Hi mpagano,
Would you mind sharing your testing result (Talend open studio products 5.2.2) with us. The feedback is very highly appreciated.
Best regards
Sabrina

[Anonymous]

I'm having the same issue in v.5.1.3 Enterprise Edition.
Do you mind posting the JavaFlex workaround? I'm not certain where the tOracleOutput code starts and stops.

[Anonymous]

Hi bentleyc,
The issue has been resolved in talend version 5.0.4, 5.1.4, 5.2.2, 5.3.0M3, perhaps you can make upgrade for your studio or download talend open studio products 5.2.2 from Talend Official Website.
Best regards
Sabrina

[_AnonymousUser]

Hi,
We are currently using TOS 5.5.1
For one of my requirement of filtering source data with timestamp (having milli second as granularity), I am storing the last timestamp in a variable and using it in sql query to filter source.
But in date variable milli seconds are getting truncated.
Why is millisecond part still getting truncted?
Please advice if there is something that am missing.
Find below two different outputs of same timestamp.
Below is from tLogRow
.-----------------------.
|       tLogRow_4       |
|=---------------------=|
|LASTEST_TIMESTAMP      |
|=---------------------=|
|2015-04-22 13:31:07.749|
'-----------------------'

Below is what stored in variable
LASTEST_TIMESTAMP: Wed Apr 22 13:31:07 AST 2015

[Anonymous]

I am using Talend DI 6.2.1.
Database :- Oracle 12c
Input is 
select TO_TIMESTAMP ((TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI S.FF')), 'YYYY-MM-DD HH24:MI S.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?