How to query dates in NoSQL : GameSparks

Start a new topic

Answered

How to query dates in NoSQL

started a topic almost 5 years ago

How can I query timestamp fields in NoSQL.

I would like a query like:

{ "when": { "$gte": new Date("2016-06-01"), "$lt": new Date("2016-07-02") }}

This is OK in MongoDB, but not in NoSQL.

Thanks for your help !

Best Answer

Customer Support said almost 5 years ago

Hi Eric,

Try this syntax in your find query.

{ "when": { "$gte": {"$date": "2016-06-01T00:00:00.000Z"}, "$lte": {"$date": "2016-07-02T00:00:00.000Z"}}}

Let me know if this works for you

-Pádraig

2 Comments

said almost 5 years ago

Answer