How to use $dateFromString in Spring MongoDB?

Question

In my document, the date field is a string "date": "01/08/2018". How can I convert it to Date object in Spring MongoDB to able to use comparator operators like "gte, lte" to other date object.

I tried:

project()

   .and(DateOperators.DateFromString.fromStringOf("date")).as("date")

It just works with fields whose format is yyyy-MM-dd, and of course I ended up with:

'Error parsing date string '26/10/2016'; 0: Unexpected character '2'

How can I pass the pattern or Is there another way to get the my goal?

Christoph Strobl · Accepted Answer · 2018-08-09 09:45:12Z

2

The format option has been added to $dateFromString in MongoDB Version 4 and is currently missing in Spring Data MongoDB. I've opened DATAMONGO-2047 to address the issue.
Meanwhile you may try the following to add it manually.

project().and(context -> {

    Document doc = DateFromString.fromStringOf("date").toDocument(context);
    doc.get("$dateFromString", Document.class).put("format", "dd/mm/yyyy");
    return doc;
}).as("date");

answered Aug 9, 2018 at 9:45

Christoph Strobl

6,73628 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

How to use $dateFromString in Spring MongoDB?

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