Four Stars

TOS DI 6.3.1 : problem with timestamp

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,



Tags (1)
Forteen Stars TRF
Forteen Stars

Re: TOS DI 6.3.1 : problem with timestamp



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?

Four Stars

Re: TOS DI 6.3.1 : problem with timestamp

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.