Skip to content

Instantly share code, notes, and snippets.

@sabueso
Created November 3, 2015 14:06
Show Gist options
  • Save sabueso/5611dad1fb54c744de06 to your computer and use it in GitHub Desktop.
Save sabueso/5611dad1fb54c744de06 to your computer and use it in GitHub Desktop.
Extract number of clientes between dates in Unifi MongoDB
db.user.find({first_seen: { $gte:(Number(ISODate("2015-02-01T00:00:00.000Z")).valueOf()/1000), $lte:(Number(ISODate("2015-02-28T00:00:00.000Z")).valueOf()/1000) } }).count()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment