Spring MongoDB - Finding Documents between two dates

Question

I am somewhat new to Java and am trying to write a query which will return the documents stored in my mongodb between two dates. I think I am close to getting it correct but am having a hard time getting there. I am receiving the date ranges in the following format:

[2017-06-29, 2017-07-05]

The dates that i am comparing are stored in the database as follows:

yyyy-MM-dd'T'HH:mm:ss-SSSS

What i have so far..

public List<VehicleStatus> getReportingDateRange(List<String> dates)  {

    DateFormat inputFormat = new SimpleDateFormat("yyyy-MM-dd");
    DateFormat outputFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss-SSSS");  

    Date startDate = outputFormat.parse(dates.get(0));      
    Date endDate = outputFormat.parse(dates.get(1));

    Query query = new Query();

    Criteria c = new Criteria().andOperator(Criteria.where("updateTime").gte(outputFormat.format(startDate)),  
            Criteria.where("updateTime").lte(outputFormat.format(endDate)));

    query.addCriteria(c);

    return this.mongoOperations.find(query, VehicleStatus.class);

   }

I am receiving a parse Exception. I am really not sure where to go from here, any help is greatly appreciated. If you need any additional information please let me know.

Thank you!

Parse Date startDate = inputFormat.parse(dates.get(0)); Date endDate = inputFormat .parse(dates.get(1)); and your dates should be stored as date type. So no parse to output format is required and Criteria c = new Criteria().andOperator(Criteria.where("updateTime").gte(startDate), Criteria.where("updateTime").lte(endDate)); — s7vr
– s7vr, Commented Jul 10, 2017 at 14:56
oh okay. try String startDate = outputFormat.format(inputFormat.parse(dates[0])); String endDate = outputFormat.format(inputFormat.parse(dates[0])); and pass this to criteria — s7vr
– s7vr, Commented Jul 10, 2017 at 15:07
@Veeram - that did the trick! Thanks so much for the help. Simple fix but something that i was clearly overlooking. Make an answer and i will make it as correct :) — reedb89
– reedb89, Commented Jul 10, 2017 at 15:18

s7vr · Accepted Answer · 2017-07-10 15:20:12Z

4

You will need to parse the date into input format followed by formatting the date to output format.

Something like

String startDate = outputFormat.format(inputFormat.parse(dates[0])); 
String endDate = outputFormat.format(inputFormat.parse(dates[0]));

Criteria c = new Criteria().andOperator(Criteria.where("updateTime").gte(star‌tDate), Criteria.where("updateTime").lte(endDate));

You should try to save the date as date type and use below version.

Date startDate = inputFormat.parse(dates.get(0)); 
Date endDate = inputFormat .parse(dates.get(1));

Criteria c = new Criteria().andOperator(Criteria.where("updateTime").gte(star‌tDate), Criteria.where("updateTime").lte(endDate));

answered Jul 10, 2017 at 15:20

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

Collectives™ on Stack Overflow

Spring MongoDB - Finding Documents between two dates

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