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 ?

score 9 · Accepted Answer · edited Jul 31 '15 at 18:00

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 '15 at 18:00

MahlerFive

5,159
5
30
40

answered May 18 '15 at 03:11

moonlighter

541
3
14

score 7 · Answer 2 · answered May 18 '15 at 07:29

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 '15 at 07:29

Deepak Agrawal

1,301
5
19
43

Work perfectly from Spring mongo Query annotation. – Rémy J May 19 '16 at 11:48
What if we are using JPA MongoRepository? how can we call the $date or isodate without getting a parse exception in @Query annotation? – user666 Dec 10 '18 at 15:04
If there is an index on dob will that be picked since it is translated to $date? – mrinal Mar 12 '19 at 11:23

score 4 · Answer 3 · answered Apr 14 '16 at 18:05

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;
        }
    }



}

This doesn't deal with T and Z in the date format :( – Kanagavelu Sugumar Jan 17 '17 at 04:49 — Kanagavelu Sugumar, Jan 17 '17 at 04:49

score 0 · Answer 4 · answered Sep 07 '20 at 16:25

0

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

answered Sep 07 '20 at 16:25

user12428264

11
2

Spring data mongodb search for ISO date

4 Answers4

Linked