Spring data mongodb search for ISO date

Question

I am trying to search for date of birth using query

criteria = Criteria.where("dob").lte(new DateTime().toDate());

And spring data mongodb generate below query:

MongoTemplate: find using query:
{ "dob" : { "$lte" : { "$date" : "2015-05-16T07:55:23.257Z"}}}
fields: null for class: class com.temp.model.User in collection: user

But I did not get any result.

My dob field in mongodb:

{"dob" : ISODate("1991-01-23T00:00:00Z")}

How I can search for dob in ISODate format ?

MahlerFive · Accepted Answer · 2015-07-31 18:00:10Z

9

This code should work fine for what you need:

criteria = Criteria.where("dob").lte(new java.util.Date());

My test is with following code, which does work fine:

Lis<User> users = mongoOps.find(query(where("isActive").is(true).and("CreatedDate").lte(new java.util.Date())), User.class);

edited Jul 31, 2015 at 18:00

MahlerFive

5,3095 gold badges33 silver badges41 bronze badges

answered May 18, 2015 at 3:11

moonlighter

5314 silver badges14 bronze badges

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

Comments

Deepak Agrawal · Accepted Answer · 2015-05-18 07:29:45Z

7

Query would execute perfect from Spring data mongodb0

{ "dob" : { "$lte" : { "$date" : "2015-05-16T07:55:23.257Z"}}}.

But It will not execute from mongo CLI.

Query to execute on cli.

{dob:ISODate("2015-05-15T07:55:23.257Z")}

Thanks

answered May 18, 2015 at 7:29

Deepak Agrawal

1,3015 gold badges20 silver badges43 bronze badges

3 Comments

Rémy J Over a year ago

Work perfectly from Spring mongo Query annotation.

user666 Over a year ago

What if we are using JPA MongoRepository? how can we call the $date or isodate without getting a parse exception in @Query annotation?

mrinal Over a year ago

If there is an index on dob will that be picked since it is translated to $date?

Dima · Accepted Answer · 2016-04-14 18:05:51Z

4

For IDE use ISODate() for SPRING DAO convert string to Date object

query.addCriteria(Criteria.where("created").ne(null).andOperator(
                Criteria.where("created").gte(DateUtils.getDate("2016-04-14 00:00:00", DateUtils.DB_FORMAT_DATETIME)),
                Criteria.where("created").lte(DateUtils.getDate("2016-04-14 23:59:59", DateUtils.DB_FORMAT_DATETIME))
            ));


public final class DateUtils {    

    public static final String DB_FORMAT_DATETIME = "yyyy-M-d HH:mm:ss";        

    private DateUtils() {
        // not publicly instantiable
    }       

    public static Date getDate(String dateStr, String format) {
        final DateFormat formatter = new SimpleDateFormat(format);
        try {
            return formatter.parse(dateStr);
        } catch (ParseException e) {                
            return null;
        }
    }



}

answered Apr 14, 2016 at 18:05

Dima

1,06514 silver badges23 bronze badges

1 Comment

Kanagavelu Sugumar Over a year ago

This doesn't deal with T and Z in the date format :(

user12428264 · Accepted Answer · 2020-09-07 16:25:40Z

0

val query = Query()
query.addCriteria( 
Criteria("info.dob").gte(dob.atStartOfDay())

answered Sep 7, 2020 at 16:25

user12428264

112 bronze badges

Collectives™ on Stack Overflow

Spring data mongodb search for ISO date

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related