How To Get Data From **realm Database** Using **date Object**?

I have tried some realm queries but not getting that result which I want let's consider below table for example(Realm table): id Name DateTimeStamp 1 A 2017-01-01 08:0

Solution 1:

You need to set up Date objects for 2017-01-01 00:00:00 and 2017-01-02 00:00:00 and query inbetween.

Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.DAY_OF_MONTH, 1); // make sure month stays valid
calendar.set(Calendar.YEAR, 2017);
calendar.set(Calendar.MONTH, Calendar.JANUARY);
calendar.set(Calendar.HOUR_OF_DAY, 0);
calendar.set(Calendar.MINUTE, 0);
calendar.set(Calendar.SECOND, 0);
calendar.set(Calendar.MILLISECOND, 0);
Date jan1 = new Date(calendar.getTimeInMillis());
calendar.set(Calendar.DAY_OF_MONTH, 2);
Date jan2 = new Date(calendar.getTimeInMillis());

Then

realm.where(ReservationObject.class)
     .greaterThanOrEqualTo("DateTimeStamp", jan1)
     .lessThan("DateTimeStamp", jan2)
     .findAll()

Solution 2:

Use contains it work like LIKE

long cnt =
 realm.where(ReservationObject.class)
 .contains("DateTimeStamp",dateObject).count();

OR Latest version have

public RealmQuery<E> like(String fieldName,
                      String value,
                      Case casing)