Back to DocumentationMQL Documentation

$hour

Returns the hour portion of a date as a number between 0 and 23. The operator accepts a date expression that resolves to a Date, Timestamp, or ObjectId.

Syntax

$hour: <dateExpression>

Parameters

dateExpressionobjectrequired

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

Examples

Extract hour from current date

This query extracts the hour from the current date and time.

Query:

db.stores.aggregate([
  { $match: { "_id": "e6410bb3-843d-4fa6-8c70-7472925f6d0a" } },
  {
    $project: {
      name: 1,
      storeOpeningDate: 1,
      currentHour: { $hour: new Date() },
      documentHour: { $hour: "$storeOpeningDate" }
    }
  }
])

Output:

[
  {
    "_id": "e6410bb3-843d-4fa6-8c70-7472925f6d0a",
    "name": "Relecloud | Toy Collection - North Jaylan",
    "storeOpeningDate": "2024-09-05T11:50:06.549Z",
    "currentHour": 12,
    "documentHour": 11
  }
]

Related