Thursday, November 21, 2024

An interesting SQL Server T-SQL datetime issue

 An interesting SQL Server T-SQL datetime issue:


Based on the official document https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-2017

datetime values are rounded to increments of .000.003, or .007 seconds, as shown in the following example.

No comments:

Post a Comment