Find objects between two dates MongoDB

Question

I ve been playing around storing tweets inside mongodb  each object looks like this       id    ObjectId  4c02c58de500fe1be1000005     contributors    null   text     Hello world    user           following    null       followers count    5       utc offset    null       location             profile text color     000000        friends count    11       profile link color     0000ff        verified    false       protected    false       url    null       contributors enabled    false       created at     Sun May 30 18 47 06  0000 2010        geo enabled    false       profile sidebar border color     87bc44        statuses count    13       favourites count    0       description             notifications    null       profile background tile    false       lang     en        id    149978111       time zone    null       profile sidebar fill color     e0ff92      geo    null   coordinates    null   in reply to user id    149183152   place    null   created at     Sun May 30 20 07 35  0000 2010    source     web    in reply to status id           floatApprox    15061797850     truncated    false   favorited    false   id           floatApprox    15061838001     How would I write a query which checks the created at and finds all objects between 18 47 and 19 00  Do I need to update my documents so the dates are stored in a specific format

User · Answer

mongoose model  ModelName   aggregate                  match                userId  mongoose Types ObjectId userId                                  project                dataList                   filter                     input    dataList                    as   item                    cond                          and                                                           gte       item dateTime   new Date  2017-01-01T00 00 00 000Z                                                                                       lte       item dateTime   new Date  2019-12-01T00 00 00 000Z

User · Answer

Querying for a Date Range  Specific Month or Day  in the MongoDB Cookbook has a very good explanation on the matter  but below is something I tried out myself and it seems to work   items save       name   example       created at  ISODate  2010-04-30T00 00 00 000Z      items find       created at             gte  ISODate  2010-04-29T00 00 00 000Z             lt  ISODate  2010-05-01T00 00 00 000Z              gt      id    ObjectId  4c0791e2b9ec877893f3363b     name     example    created at     Sun May 30 2010 00 00 00 GMT 0300  EEST       Based on my experiments you will need to serialize your dates into a format that MongoDB supports  because the following gave undesired search results   items save       name   example       created at   Sun May 30 18 49 00  0000 2010     items find       created at             gte  Mon May 30 18 47 00  0000 2015            lt   Sun May 30 20 40 36  0000 2010             gt      id    ObjectId  4c079123b9ec877893f33638     name     example    created at     Sun May 30 18 49 00  0000 2010      In the second example no results were expected  but there was still one gotten  This is because a basic string comparison is done

User · Answer

use  gte and  lte to find between date data s in mongodb  var tomorrowDate   moment new Date    add 1   days   format  YYYY-MM-DD    db collection find   plannedDeliveryDate     gte  new Date tomorrowDate   T00 00 00 000Z    lte  new Date tomorrowDate    T23 59 59 999Z

User · Answer

Convert your dates to GMT timezone as you re stuffing them into Mongo   That way there s never a timezone issue   Then just do the math on the twitter timezone field when you pull the data back out for presentation

User · Answer

To clarify  What is important to know is that    Yes  you have to pass a Javascript Date object    Yes  it has to be ISODate friendly Yes  from my experience getting this to work  you need to manipulate the date to ISO Yes  working with dates is generally always a tedious process  and mongo is no exception   Here is a working snippet of code  where we do a little bit of date manipulation to ensure Mongo  here i am using mongoose module and want results for rows whose date attribute is less than  before  the date given as myDate param  can handle it correctly   var inputDate   new Date myDate toISOString     MyModel find        date      lte  inputDate

User · Answer

db collection find   createdDate    gte new ISODate  2017-04-14T23 59 59Z    lte new ISODate  2017-04-15T23 59 59Z      count      Replace collection with name of collection you want to execute query

User · Answer

Using with Moment js and Comparison Query Operators    var today   moment   startOf  day          2018-12-05T00 00 00 00   var tomorrow   moment today  endOf  day           2018-12-05T23 59 59 999    Example find             find in today     created      gte   today    lte   tomorrow          Or greater than 5 days        created     lt  moment   add -5   days            function  err  docs

User · Answer

db collection find   and           date time   gt ISODate  quot 2020-06-01T00 00 00 000Z quot            date time   lt ISODate  quot 2020-06-30T00 00 00 000Z quot                 In case you are making the query directly from your application     db collection find   and             date time   gt  quot 2020-06-01T00 00 00 000Z quot           date time   lt  quot 2020-06-30T00 00 00 000Z quot

User · Answer

You can also check this out  If you are using this method  then use the parse function to get values from Mongo Database   db getCollection  user   find       createdOn             gt  ISODate  2020-01-01T00 00 00 000Z             lt  ISODate  2020-03-01T00 00 00 000Z

User · Answer

Why not convert the string to an integer of the form YYYYMMDDHHMMSS   Each increment of time would then create a larger integer  and you can filter on the integers instead of worrying about converting to ISO time

User · Answer

i tried in this model as per my requirements i need to store a date when ever a  object is created later i want to retrieve all the records  documents   between two dates  in my html file i was using the following format mm dd yyyy   lt  DOCTYPE html PUBLIC  -  W3C  DTD HTML 4 01 Transitional  EN  gt    lt html gt   lt head gt        lt script gt    jquery       document  ready function              select date   click function            ajax       type   post       url   xxx        datatype   html       data      period   serialize          success  function data       alert data            success            event triggered           ajax          jquery        lt  script gt        lt title gt  lt  title gt   lt  head gt    lt body gt       lt form id  period  name  period  gt          from  lt input id  selecteddate  name  selecteddate1  type  text  gt  to           lt input id  select date  type  button  value  selected  gt       lt  form gt   lt  body gt   lt  html gt    in my py  python  file i converted it into  iso fomate  in following way  date str1     request POST  SelectedDate1    SelectedDate1     datetime datetime strptime date str1    m  d  Y   isoformat     and saved in my dbmongo collection with  SelectedDate  as field in my collection   to retrieve data or documents  between to 2 dates i used following query  db collection find   SelectedDate      gte   SelectedDate1   lt   SelectedDate2

User · Answer

MongoDB actually stores the millis of a date as an int 64   as prescribed by http   bsonspec org   specification  However  it can get pretty confusing when you retrieve dates as the client driver will instantiate a date object with its own local timezone  The JavaScript driver in the mongo console will certainly do this   So  if you care about your timezones  then make sure you know what it s supposed to be when you get it back  This shouldn t matter so much for the queries  as it will still equate to the same int 64   regardless of what timezone your date object is in  I hope   But I d definitely make queries with actual date objects  not strings  and let the driver do its thing

User · Answer

Python and pymongo  Finding objects between two dates in Python with pymongo in collection posts  based on the tutorial    from date   datetime datetime 2010  12  31  12  30  30  125000  to date   datetime datetime 2011  12  31  12  30  30  125000   for post in posts find   date      gte   from date    lt   to date         print post    Where    gte   from date    lt   to date  specifies the range in terms of datetime datetime types

User · Answer

Use this code to find the record between two dates using  gte and  lt   db CollectionName find   whenCreated           gte   ISODate  2018-03-06T13 10 40 294Z          lt   ISODate  2018-05-06T13 10 40 294Z

[mongodb] Find objects between two dates MongoDB

Examples related to mongodb

Examples related to datetime

Examples related to twitter

Examples related to mongodb-query