Issue with creating a query in mongodb with NumberLong

Question

I've got a class in my Java application with field

Instant created;

This one is stored in mongo as

"created" : NumberLong("1467359610266") (f.e.)

I want to create a query to get all the documents, that was created beetween 2 dates:

    public List<MarketingEmail> find(Long startDate, Long endDate) {
    Query query = new Query();
    query.addCriteria(Criteria.where("created").gte(startDate).lte(endDate));
    ...
}

I pass the timestamp variables startDate and endDate (f.e. endDate = 1467981757). So the issues is that NumberLong in MongoDB has 13 digits, when my timestamp has ony 10; so my query doesn't work at all

How can i solve this issue?

profesor79 · Accepted Answer · 2016-07-08 13:41:06Z

2

Mongo timestamp uses milliseconds.

To query it multiply your value by 1000 (or simple add 000 at the end)

answered Jul 8, 2016 at 13:41

profesor79

9,5033 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue with creating a query in mongodb with NumberLong

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related