Datetime Imported from external system

 

SQL Server accuracy of milliseconds is 1/300^th of a second and the possible values are .000, .003 and .007. Any datetime value in SQL Server with milliseconds will be rounded to one the nearest of these three values.

The table lists all possible last digit of millisecond

 

Original/Import millisecond	SQL Server Millisecond	Difference
.000	.000	0
.001	.000	-1
.002	.003	+1
.003	.003	0
.004	.003	-1
.005	.007	+2
.006	.007	+1
.007	.007	0
.008	.007	-1
.009	.010	+1

 

Whilst you compare values, SQL Server interprets milliseconds the same way i.e., it converts the value to SQL Server compabile and compares it, hence, No issue if the values are compared within SQL Server.