Back to DocumentationMQL Documentation

$millisecond

Extracts the milliseconds portion from a date value, returning a number between 0 and 999. This operator is useful for precise timestamp analysis and filtering operations that require millisecond-level granularity.

Syntax

$millisecond: <dateExpression>

Parameters

dateExpressionobjectrequired

An expression that resolves to a Date, a Timestamp, or an ObjectId. If the expression resolves to null or is missing, $millisecond returns null.

Examples

Extract milliseconds from store opening date

This query extracts the milliseconds portion from the store opening date.

Query:

db.stores.aggregate([
  { $match: {_id: "905d1939-e03a-413e-a9c4-221f74055aac"} },
  {
    $project: {
      name: 1,
      storeOpeningDate: 1,
      openingMilliseconds: {
        $millisecond: "$storeOpeningDate"
      }
    }
  }
])

Output:

[
  {
    "_id": "905d1939-e03a-413e-a9c4-221f74055aac",
    "name": "Trey Research | Home Office Depot - Lake Freeda",
    "storeOpeningDate": ISODate("2024-09-26T22:55:25.779Z"),
    "openingMilliseconds": 779
  }
]

Related