SQL vs MongoDB

Costas

Administrator
Staff member
JavaScript:
SELECT  *
FROM    users
WHERE   signup_time >= CURDATE() - INTERVAL 1 DAY
 
 
MongoDB (convert the 24 hours to milliseconds on your own)
JavaScript:
db.users.find({
  "signup_time": {
    $gt: new Date(Date.now() - 24*60*60 * 1000)
  }
})

ref - https://stateofprogress.blog/choose-sql-d017cfc08870
 
 
Convert MySQL Queries to MongoDB Syntax
http://www.querymongo.com/
 
Top