return query based on date

Question

I have a data like this in mongodb          latitude              longitude              course              battery     0         imei     0         altitude     F 3 82V         mcc     07         mnc     007B         lac     2A83          id    ObjectId  4f0eb2c406ab6a9d4d000003          createdAt    ISODate  2012-01-12T20 15 31Z        How do I query db gpsdatas find   createdAt     what here      so that it returns the above data result to me from the db

User · Accepted Answer

You probably want to make a range query  for example  all items created after a given date   db gpsdatas find   createdAt       gte   new ISODate  2012-01-12T20 15 31Z          I m using  gte  greater than or equals   because this is often used for date-only queries  where the time component is 00 00 00   If you really want to find a date that equals another date  the syntax would be  db gpsdatas find   createdAt    new ISODate  2012-01-12T20 15 31Z

User · Answer

Just been implementing something similar in Mongo v3 2 3 using Node v0 12 7 and v4 4 4 and used      gte  new Date dateVar  toISOString       I m passing in an ISODate  e g  2016-04-22T00 00 00Z  and this works for a  find   query with or without the toISOString function  But when using in an  aggregate    match query it doesn t like the toISOString function

User · Answer

You can also try          dateProp      gt  new Date  06 15 2016   getTime

User · Answer

If you want to get all new things in the past 5 minutes you would have to do some calculations  but its not hard     First create an index on the property you want to match on  include sort direction -1 for descending and 1 for ascending   db things createIndex   createdAt  -1       descending order on  createdAt   Then query for documents created in the last 5 minutes  60 seconds   5 minutes     because javascript s  getTime   returns milliseconds you need to mulitply by 1000 before you use it as input to the new Date   constructor   db things find           createdAt                 gte  new Date new Date   getTime  -60 5 1000  toISOString                            count     Explanation for new Date new Date   getTime  -60 5 1000  toISOString   is as follows   First we calculate  5 minutes ago      new Date   getTime   gives us current time in milliseconds We want to subtract 5 minutes  in ms  from that  5 60 1000 -- I just multiply by 60 seconds so its easy to change  I can just change 5 to 120 if I want 2 hours  120 minutes   new Date   getTime  -60 5 1000 gives us 1484383878676  5 minutes ago in ms    Now we need to feed that into a new Date   constructor to get the ISO string format required by MongoDB timestamps       gte  new Date resultFromAbove  toISOString      mongodb  find   query  Since we can t have variables we do it all in one shot  new Date new Date   getTime  -60 5 1000     then convert to ISO string   toISOString   new Date new Date   getTime  -60 5 1000  toISOString   gives us 2017-01-14T08 53 17 586Z   Of course this is a little easier with variables if you re using the node-mongodb-native driver  but this works in the mongo shell which is what I usually use to check things

User · Answer

Find with a specific date   db getCollection  CollectionName   find   DepartureDate    new ISODate  2019-06-21T00 00 00 000Z       Find with greater gte or little lt    db getCollection  CollectionName   find   DepartureDate       gte   new ISODate  2019-06-11T00 00 00 000Z         Find by range   db getCollection  CollectionName   find         DepartureDate               lt  new Date              gte  new Date new Date   setDate new Date   getDate  -15

User · Answer

If you are using Mongoose   try     const data   await GPSDatas aggregate                match    createdAt      gt  new Date                         sort    createdAt  1                console log data     catch error        console log error

User · Answer

if you want to get items anywhere on that date you need to compare two dates You can create two dates off of the first one like this  to get the start of the day  and the end of the day  var startDate   new Date       this is the starting date that looks like ISODate  quot 2014-10-03T04 00 00 188Z quot    startDate setSeconds 0   startDate setHours 0   startDate setMinutes 0    var dateMidnight   new Date startDate   dateMidnight setHours 23   dateMidnight setMinutes 59   dateMidnight setSeconds 59        MONGO QUERY  var query             inserted at                         gt morning                       lt dateScrapedMidnight                 MORNING  Sun Oct 12 2014 00 00 00 GMT-0400  EDT    MIDNIGHT  Sun Oct 12 2014 23 59 59 GMT-0400  EDT

[mongodb] return query based on date

Examples related to mongodb