MongoDB Mongoose querying at a specific date

Question

Is it possible to query for a specific date    I found in the mongo Cookbook that we can do it for a range Querying for a Date Range Like that    db posts find   created on      gte   start    lt   end      But is it possible for a specific date   This doesn t work    db posts find   created on   new Date 2012  7  14

User · Answer

5  years later  I strongly suggest using date-fns instead  import endOfDayfrom  date-fns endOfDay  import startOfDay from  date-fns startOfDay   MyModel find     createdAt         gte  startOfDay new Date          lte  endOfDay new Date             For those of us using Moment js  const moment   require  moment    const today   moment   startOf  day    MyModel find     createdAt         gte  today toDate         lte  moment today  endOf  day   toDate            Important  all moments are mutable   tomorrow   today add 1   days   does not work since it also mutates today  Calling moment today  solves that problem by implicitly cloning  today

User · Answer

Have you tried   db posts find   created on      gte   new Date 2012  7  14     lt   new Date 2012  7  15       The problem you re going to run into is that dates are stored as timestamps in Mongo  So  to match a date you re asking it to match a timestamp   In your case I think you re trying to match a day  ie  from 00 00 to 23 59 on a specific date   If your dates are stored without times then you should be okay  Otherwise  try specifying your date as a range of time on the same day  ie  start 00 00  end 23 59  if gte doesn t work   similar question

User · Answer

You can use following approach for API method to get results from specific day      HTTP GET  getMeals   req  res  - gt    options          eg  api v1 meals date Tue Jan 13 2015 00 3A00 3A00 GMT 2B0100  CET    if req query date      date   new Date req query date     date setHours 0  0  0  0     endDate   new Date date     endDate setHours 23  59  59  59     options date          lt  endDate        gte  date    Meal find options   err  meals  - gt        if err or not meals         handleError err  meals  res       else         res json createJSON meals  null   meals

User · Answer

We had an issue relating to duplicated data in our database  with a date field having multiple values where we were meant to have 1  I thought I d add the way we resolved the issue for reference   We have a collection called  data  with a numeric  value  field and a date  date  field  We had a process which we thought was idempotent  but ended up adding 2 x values per day on second run       id     1    type   x    value  1 23  date   ISODate  2013-05-21T08 00 00Z        id     2    type   x    value  1 23  date   ISODate  2013-05-21T17 00 00Z      We only need 1 of the 2 records  so had to resort the javascript to clean up the db  Our initial approach was going to be to iterate through the results and remove any field with a time of between 6am and 11am  all duplicates were in the morning   but during implementation  made a change  Here s the script used to fix it   var data   db data find   type     x    var found       while  data hasNext         var datum   data next        var rdate   datum date         instead of the next set of conditions  we could have just used rdate getHour   and checked if it was in the morning  but this approach was slightly better        if  typeof found rdate getDate    -  rdate getMonth      -    rdate getFullYear         undefined            if  datum value    found rdate getDate    -  rdate getMonth      -    rdate getFullYear                  print  DISCREPENCY         datum  id     for date     datum date                   else              print  Removing     datum  id              db data remove     id   datum  id                       else          found rdate getDate    -  rdate getMonth      -    rdate getFullYear      datum value            and then ran it with mongo thedatabase fixer script js

User · Answer

Yeah  Date object complects date and time  so comparing it with just date value does not work    You can simply use the  where operator to express more complex condition with Javascript boolean expression     db posts find     where    this created on toJSON   slice 0  10      2012-07-14        created on is the datetime field and 2012-07-14 is the specified date   Date should be exactly in YYYY-MM-DD format   Note  Use  where sparingly  it has performance implications

User · Answer

That should work if the dates you saved in the DB are without time  just year  month  day   Chances are that the dates you saved were new Date    which includes the time components  To query those times you need to create a date range that includes all moments in a day  db posts find     query today up to tonight     created on             gte  new Date 2012  7  14             lt  new Date 2012  7  15

[node.js] MongoDB/Mongoose querying at a specific date?

...5+ years later, I strongly suggest using date-fns instead

For those of us using Moment.js

Examples related to node.js

Examples related to mongodb

Examples related to express

Examples related to mongoose

Examples related to odm