DEV Community

Cover image for How to query date range in Mongo
Adrian Matei for Codever

Posted on • Edited on • Originally published at codever.dev

7 1

How to query date range in Mongo

Use only the date1 part

In the following example only the date part is set. Time is set to by default to 00:00:00. So the following query compares all entries archived within a day (2021-06-14):

var start = new Date("2021-06-14");
var end = new Date("2021-06-15");

db.call_archive.find({
  archivedAt: {$gte: start, $lt: end}
}).pretty();

Enter fullscreen mode Exit fullscreen mode

Use both date and time

You can also specify the Time in ISO format

  • new Date("<YYYY-mm-ddTHH:MM:ss>") - specifies the datetime in the client's local timezone and returns the ISODate with the specified datetime in UTC
  • new Date("<YYYY-mm-ddTHH:MM:ssZ>") - specifies the datetime in UTC and returns the ISODate with the specified datetime in UTC
var start = new Date("2021-06-14");
var end = new Date("2021-06-15");

db.call_archive.find({
  archivedAt: {$gte: start, $lt: end}
}).sort({archivedAt: -1}).pretty(); //sort descending

Enter fullscreen mode Exit fullscreen mode

Shared with ❤️ from Codever. 👉 Use the Copy to mine functionality to copy the snippet to your own personal collection and easy manage your code snippets.


  1. https://docs.mongodb.com/manual/reference/method/Date/ 

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay