Why is TIMESTAMP fractional seconds off by .001 when exported from DB2 to MSSQL data type DATE, DATETIME, TIMESTAMP not as VARCHAR()
When I export TIMESTAMP data type from DB2 to MSSQL data types DATE, DATETIME or TIMESTAMP the fractional time is off by .001. If I export as data type VARCHAR() I get the correct data. Is there an explanation and/or solution for this? I have exported through SSIS and PENTAHO. DB2 2021-10-20-21.31.41.138000 MSSQL 2021-10-20 21:31:41.137… Read More Why is TIMESTAMP fractional seconds off by .001 when exported from DB2 to MSSQL data type DATE, DATETIME, TIMESTAMP not as VARCHAR()