Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-21342

Use full millisecond precision on SQL Server

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.1
    • Component/s: Core, Core VCS

      Description

      SQL Server has a datetime datatype that looks like it stores millisecond precision but the actual internal precision is 1/300 s, which may cause rounding to the previous/next milllisecond on storage.

      Since SQL Server 2008, a datetime2 datatype is available that can store full milliseconds (https://msdn.microsoft.com/en-us/library/bb677335.aspx).

      Use this feature.

      In addition to the added precision, this allows us to simplify some special cases in a number of unit tests.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: