Child pages
  • Determining the Earliest Data Stored

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
[root@demo:~]# mongo -u opUserRW -p op42flow42 flows --eval 'db.conversations.find(null,{time:1}).sort({time:1}).limit(1);'
{ "_id" : ObjectId("5a77fbc7b0d1e62e546585f5"), "time" : 1517812543.171 }

[root@demo:~]# date -d @1517812543.171
Mon Feb  5 16:35:43 AEST 2018

...

Code Block
[root@demo:~]# mongo -u opUserRW -p op42flow42 flows --eval 'db.summary_hourly.find(null,{time:1}).sort({time:1}).limit(1);'
{ "_id" : ObjectId("59cb0d3fb0d1e634aa7832be"), "time" : 1506474000 }

[root@demo:~]# date -d @1506474000
Wed Sep 27 11:00:00 AEST 2017