I have this documents in a timeseries collection:
{
"ts" : ISODate("2000-12-31T23:00:00.000+0000"),
"meta" : {
"addr" : "a1",
"device" : "test01",
"series" : "test01:a1"
},
"v" : 100.84432598221046
}
{
"ts" : ISODate("2001-01-01T23:00:00.000+0000"),
"meta" : {
"addr" : "a1",
"device" : "test01",
"series" : "test01:a1"
},
"v" : 200.14378032120374
}
...
and if I execute the following query:
db.getCollection("timeseries").find({
"meta.series": "test01:a1",
"ts": { "$gte": ISODate("1970-01-01")}
})
MongoDB returns me 0 documents!!!
While if I execute this one (epoch + 1 day):
db.getCollection("timeseries").find({
"meta.series": "test01:a1",
"ts": { "$gte": ISODate("1970-01-02")}
})
it works!!