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

Fix how SQL Server 2008+ stores dates

    XMLWordPrintable

    Details

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

      Description

      Actually Nuxeo VCS use the datetime column type to store dates. The problem is that type does not take into account the timezone set with the date, and as a consequence, setting a date with any of these values

      2013-07-10T18:30:00.436+03:00

      or

      2013-07-10 18:30:00.436

      stores the same value !

      Since SQL Server 2008, a new type datetimeoffset was introduced that may help to improve the storage of dates from Nuxeo

        Attachments

          Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. NXP-12220 Allow storage of dates with timezones

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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: