Showing results for 
Search instead for 
Did you mean: 
Status: New

MS SQL Datetime2(7)  Appears as a timestamp in this format:  YYYY-MM-DD hh:mm:ss.mmmmmmm

Incorta Spark SQL is truncating this to YYYY-MM-DD hh:mm:ss.mmm.

This causes issues in transactional data where a wider precision level is needed to accurately reflect or pick up the proper record for a transaction on a between join clause. The truncated value that incorta uses can cause duplicates in data.