topic TOS DI 6.3.1 : problem with timestamp in Talend Studio

TOS DI 6.3.1 : problem with timestamp

Anonymous — Thu, 01 Jun 2017 11:04:36 GMT

Hello to all, i have a problem with a copy of timestamp which truncates nanoseconds (,000000001 becomes ,000000000).

Do you have an idea on this issue ?

My data provide from Oracle 11g databases and I use TOS DI 6.3.1 (free tool).

Thanks in advance,

Best regards,

Bertrand

Re: TOS DI 6.3.1 : problem with timestamp

TRF — Thu, 01 Jun 2017 11:08:45 GMT

Hi,

Can you give a little bit more details?

What datatype are you using to store these timestamps?

Which components are using?

Do you know the step in which the truncation occurs?

Re: TOS DI 6.3.1 : problem with timestamp

Anonymous — Thu, 01 Jun 2017 11:21:48 GMT

More details :

I copy the same table between 2 Oracle databases : I use tOracleInput and tOracleOutput components. The 2 tables have the same structure. IN the Tmap, timestamps have date structure.

In my imput table I Have a Timestamp(9) ; examples : 25/05/17 15:05:06,000000001 to 25/05/17 15:05:06,000000143

After my copy, the result is : 25/05/17 15:05:06,000000000 for all the lines in the output table. In fact , I lose the precision for the nanoseconds.