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

Use DATETIME2 for SQL Server date storage

    XMLWordPrintable

    Details

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

      Description

      Since SQL Server 2008 the new datatype DATETIME2 is available, it has millisecond accuracy (and more) and should be used in preference to DATETIME according to Microsoft documentation.

      —> Switch to that.

        Attachments

          Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. NXP-21338 Use millisecond precision on MySQL/MariaDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-20313 Fix failure on TestSQLRepositoryQuery.testEqualsTimeWithMilliseconds on mssql

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: