MongoDB: how to parse date in 3.6 mongoDb version?

by

Use $dateToParts and its counterpart $dateFromParts

Here is an updated Playground

What it does is basically break the date into its parts:

{
  $project: {
    dateHour: {
      $dateToParts: {
        date: "$updatedAt"
      }
    }
  }
}

would produce:

{
  "dateHour": {
    "day": 19,
    "hour": 18,
    "millisecond": 0,
    "minute": 21,
    "month": 3,
    "second": 5,
    "year": 2020
  }
}

and then later you reconstruct the date from its parts:

{
  $project: {
    reconstructedDateHour: {
      $dateFromParts: {
        year: "$dateHour.year",
        month: "$dateHour.month",
        day: "$dateHour.day",
        hour: "$dateHour.hour"
      }
    }
  }
}

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Moongoose aggregate $match does not match id’s
  3. How to return just the nested documents of an array from all documents
  4. MongoDB: Calculate dwell time between every status value change
  5. Mongodb aggregation $group, restrict length of array
  6. $project in $lookup mongodb
  7. Mongodb, aggregate query with $lookup
  8. Retrieve only the queried element in an object array in MongoDB collection
  9. Update MongoDB field using value of another field
  10. $lookup on ObjectId’s in an array
  11. Return only matched sub-document elements within a nested array
  12. Converting string to date in mongodb
  13. Check if every element in array matches condition
  14. MongoError: The ‘cursor’ option is required, except for aggregate with the explain argument
  15. MongoDB nested lookup with 3 levels
  16. MongoDB Full and Partial Text Search
  17. Matching ObjectId to String for $graphLookup
  18. Mongodb Join on _id field from String to ObjectId
  19. Mongodb aggregation lookup with conditions
  20. How to get back the Original document back after aggregation
  21. Mongo sort on a calculated condition
  22. MongoDB lookup when foreign field is an array of objects
  23. Search on multiple collections in MongoDB
  24. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  25. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  26. Remove Duplicates from MongoDB
  27. How to access overall document count during arithmetic aggregation expression
  28. count array occurrences across all documents with mongo
  29. Mongodb concat int and string
  30. Return actual type of a field in MongoDB

Leave a Comment