MongoDB में ISODate से Month, Day, Year आदि Fetch करना

Mongo shell विभिन्न methods provide करता है जैसे ISODate() date return करने के लिए, either string या Date object के रूप में। ISODate() constructor ISODate() wrapper का उपयोग करके Date object return करता है।

Collection बनाना

> db.demo548.insertOne({"dueDate":new ISODate("2020-04-09 12:12:40")});
{ "acknowledged" : true, "insertedId" : ObjectId("5e8e30499e5f92834d7f05de") }

सभी Documents Display करना

> db.demo548.find();

Output:

{ "_id" : ObjectId("5e8e30499e5f92834d7f05de"), "dueDate" : ISODate("2020-04-09T12:12:40Z") }

ISODate से Date Components Extract करने का Query

> db.demo548.aggregate( [ { $project: { Year: { $year: "$dueDate" }, Month: { $month: "$dueDate" }, Day: { $dayOfMonth: "$dueDate" }, Hour: { $hour: "$dueDate" }, Minutes: { $minute: "$dueDate" }, Seconds: { $second: "$dueDate" }, Milliseconds: { $millisecond: "$dueDate" }, DayOfYear: { $dayOfYear: "$dueDate" }, DayOfWeek: { $dayOfWeek: "$dueDate" }, Week: { $week: "$dueDate" } } } ] ).pretty();

Output:

{
  "_id" : ObjectId("5e8e30499e5f92834d7f05de"),
  "Year" : 2020,
  "Month" : 4,
  "Day" : 9,
  "Hour" : 12,
  "Minutes" : 12,
  "Seconds" : 40,
  "Milliseconds" : 0,
  "DayOfYear" : 100,
  "DayOfWeek" : 5,
  "Week" : 14
}

उपलब्ध Date Operators: $year, $month, $dayOfMonth, $hour, $minute, $second, $millisecond, $dayOfYear, $dayOfWeek (1=Sunday), $week। ये सभी $project stage में use होते हैं।