If column is time(x) and TVP is used (with either ResultSet, Stored Procedure or SQLServerDataTable). The milliseconds or nanoseconds are not copied into the destination table.
For example:
if source column time(4) is: 15:39:27.6167
destination column time(4) will be: 15:39:27.0000
it only happens for time column. datetime2 and datetimeoffset are working correct.
If column is
time(x)and TVP is used (with either ResultSet, Stored Procedure or SQLServerDataTable). The milliseconds or nanoseconds are not copied into the destination table.For example:
if source column time(4) is: 15:39:27.6167
destination column time(4) will be: 15:39:27.0000
it only happens for time column. datetime2 and datetimeoffset are working correct.