[AccessD] Access + SQL Server Date/Time Conclusions

Stuart McLachlan stuart at lexacorp.com.pg
Tue Jul 5 16:42:55 CDT 2022


On 6 Jul 2022 at 9:08, Paul Wolstenholme wrote:

> As a side note, I would assert that the resolution of datetime is up 4ms

Actually 3 or 4ms 
No need to assert it, it's documented at
https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-
ver16

"Accuracy      Rounded to increments of .000, .003, or .007 seconds"





More information about the AccessD mailing list