android - Firebase endAt() not working with date string?

Question

Pretty basic question in here

My Stored Date String is like this in Firebase DB

23-Oct-2016 07:00:11 AM

Now i am firing this query , i am getting all the data starting with that date

   Query query = mDatabase.orderByChild("time").startAt("23-Oct-2016")

Now I also want to filter by current AM/PM time i am trying query like this but it has no effect on results.

Basically it should not return any object if the current time is PM , i don't know why its not working .

   Query query = mDatabase.orderByChild("time").startAt("23-Oct-2016").endAt("PM");

Answer 1

Waitting for answers