MongoDB provides quite a few aggregation pipeline operators for working with dates. This includes operators that extract certain parts of dates, such as the year, month, day, etc.
There are also a couple of MongoDB methods that enable you to iterate through a cursor, and apply a JavaScript function. This therefore allows you to use JavaScript to extract date values and date parts, etc from a field.
This article presents 6 ways to return the year portion from a date in MongoDB.
This article contains a list of date operators, methods, and variables that you can use when working with dates in MongoDB.
In MongoDB, the Date() method returns a date either as a string or as a Date object.
Date(), it returns the current date as a string in the mongo shell.new Date(), it returns the current date as a Date object. You can also provide a specific date as an argument to new Date(), so that it uses that date.
MongoDB provides the NOW system variable that allows you to get the current datetime value when using an aggregation pipeline.
This can be useful for when you want to update a document with the current datetime.
In MongoDB, the $dateFromParts aggregation pipeline operator constructs and returns a Date object from the date’s constituent parts.
You provide each date part as a separate field.
You can specify your constituent date fields in ISO week date format if required.
In MongoDB, the $dateToParts aggregation pipeline operator returns the date parts of a given date.
More specifically, it returns a document that contains the constituent parts of a given BSON Date value as individual properties.
In MongoDB, the $dateToString aggregation pipeline operator converts a given date object to a string.
The $dateToString operator accepts either a Date, a Timestamp, or an ObjectId.
The following table outlines the format specifiers that can be used with the $dateToString aggregation pipeline operator in MongoDB.
In MongoDB, the $dateFromString aggregation pipeline operator converts a date/time string to a date object.
The following table outlines the format specifiers that can be used with the $dateFromString aggregation pipeline operator in MongoDB.