Query Mongodb on month, day, year… of a datetime

by

Dates are stored in their timestamp format. If you want everything that belongs to a specific month, query for the start and the end of the month.

var start = new Date(2010, 11, 1);
var end = new Date(2010, 11, 30);

db.posts.find({created_on: {$gte: start, $lt: end}});
//taken from http://cookbook.mongodb.org/patterns/date_range/

More Related Contents:

  1. Append item to MongoDB document array in PyMongo without re-insertion
  2. Append item to MongoDB document array in PyMongo without re-insertion
  3. How to convert a pymongo.cursor.Cursor into a dict?
  4. How to continue insertion after duplicate key error using PyMongo
  5. mongodb: insert if not exists
  6. How to import data from mongodb to pandas?
  7. search by ObjectId in mongodb with pymongo
  8. Insert a Pandas Dataframe into mongodb using PyMongo
  9. How to sort mongodb with pymongo
  10. Authenticate After Picking the Database
  11. Fast or Bulk Upsert in pymongo
  12. How to make a query date in mongodb using pymongo?
  13. How to Ignore Duplicate Key Errors Safely Using insert_many
  14. Getting Spark, Python, and MongoDB to work together
  15. Using .sort with PyMongo
  16. How to run raw mongodb commands from pymongo
  17. ImportError: No module named objectid
  18. How to compare two dates?
  19. Plotting dates on the x-axis with Python’s matplotlib
  20. datetime dtypes in pandas read_csv
  21. pandas dataframe groupby datetime month
  22. pytz localize vs datetime replace
  23. Find the end of the month of a Pandas DataFrame Series
  24. Generate a list of datetimes between an interval
  25. Specifying date format when converting with pandas.to_datetime
  26. Get UTC offset from time zone name in python
  27. Python: Datetime to season
  28. finding last business day of a month in python
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment