Talend DATETIME2 auto rounding a value

[rdentsu]

Hi, all. I have I have SQL Server input and output components with some DATETIME2 column, however the column with DATETIME2 data type in the resulting destination table is different from source. Example if the source like this "2022-04-21 23:48:23.1680000", but the result on destination table like this "2022-04-21 23:48:23.1666667".

Can you guys explain and help me to fix this issue? if I can't get 7 digit in the last DATETIME2, at least the result same with source. like this "

2022-04-21 23:48:23.168" is not problem for me, but with data type is still DATETIME2. And Date Pattern schema I specified the format like

"yyyy-MM-dd HH:mm:ss.SSSSSSS" and I give the precision "7".

Thank you.

[Anonymous]

below are the jar location folders where you can check the driver versions which are used by studio.

JTDS:

<studio installation directory>\configuration\.m2\repository\net\sourceforge\jtds\jtds\1.3.1-patch-20190523

Microsoft driver:

<studio installation directory>\configuration\.m2\repository\org\talend\libraries\mssql-jdbc

[rdentsu]

I see, thankyou very much Mr. Shong

[rdentsu]

Hi, Shong. I have another question about datetime2 using Microsoft Driver. when the input like this:

Source data : 2021-03-18 13:46:43.5363840

target data : 2021-03-18 13:46:43.5360000

data from .536 was converted to 0000, are you have any suggestion to make the data still like Source (.5363840)?