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/