Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-1460

BSON should offer a high resolution 'UTC datetime' field type.

    • Type: Icon: New Feature New Feature
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.5.2
    • Component/s: Usability
    • Environment:
      all
    • Query Optimization

      The BSON spec defines a 'UTC datetime' field, specified as number of milliseconds since the epoch. However, milliseconds is often far too coarse grained for recording timestamps in high performance systems. It is also rather wasteful of the entire 64 bit range. A signed 64 bit integer can represent slightly less than 300 milliion years worth of milliseconds. That is a very long time.

      The BSON spec should offer a high resolution UTC datetime type, denominated either in microseconds (almost 300,000 years in an int64_t), or even nanoseconds (still almost 300 years). Perhaps both?

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            andrew.morrow@mongodb.com Andrew Morrow (Inactive)
            Votes:
            11 Vote for this issue
            Watchers:
            22 Start watching this issue

              Created:
              Updated: