Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-84513

Increase precision of type datetime for SQL Server

    Details

      Description

      In SQL Server the type DATETIME has smaller precision that a millisecond. In particular, time values will be rounded to one of the following values: .xx0 s, .xx3 s, or .xx7 s. 

      Starting with version 2008, the new type DATETIME2 was introduced which can allow up to a precision of 100 ns. The precision can be customized using the type DATETIME2(p), where p can range from 0 to 7, with a default value of 7. 

      Using DATETIME can lead to problems when comparing dates. See LPS-84506 for an example. 

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                koor.gai Koor Gai
                Reporter:
                ricardo.couso Ricardo Couso
                Recent user:
                Enterprise Release HU
                Participants of an Issue:
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  7.2.X
                  Master