Mongo: Getting current time in milliseconds since 1970

Question

In Mongodb I have a field representing a timestamp (milliseconds since 1970), but it is in fact a long saved from Python.

I now want to get all entries done after a certain time. I cannot find a way though how to get the current time as a timestamp in a mongo shell style. One thing I've tried e.g. was:

use binfut;
db.getCollection("liq").aggregate(
    [
        { 
            "$match" : { 
                "coin" : "BTC-USDT", 
                "side" : "SELL", 
                "timestamp" : { 
                    "$lte" : ISODate("2018-10-02T01:11:18.965+0000")
                }
            }
        }
    ], 
    { 
        "allowDiskUse" : false
    }
);

But I also used new Date(), etc.

Is there a way to get this done?

Maybe `{$expr: {$lte:[{$toDate: "$timestamp"}, ISODate("2018-10-02T01:11:18.965+0000")]}}` — Wernfried Domscheit, Dec 01 '20 at 19:09
Perhaps `timestamp: {$gte: (new ISODate("2018-10-02T01:11:18.965+0000")).valueOf()}` — Joe, Dec 01 '20 at 19:35

score 0 · Answer 1 · answered Dec 01 '20 at 20:22

0

See How do you get a timestamp in JavaScript?.

> +ISODate("2018-10-02T01:11:18.965+0000")
1538442678965

answered Dec 01 '20 at 20:22

D. SM

13,584
3
12
21

It's not about javascript, but mongo shell ;) – MPL Dec 01 '20 at 20:57
What language do you think the shell uses? – D. SM Dec 01 '20 at 22:40

Mongo: Getting current time in milliseconds since 1970

1 Answers1