Query parse.com by time, not date

Question

Is there a way to query from parse.com CreatedAt column by the time only? My goal is to query all the records that were CreatedAt between say 6 and 12 o'clock regardless of the date (though I will need to attach some date range also). I am using parse's .NET API. In my mind I thought something like this might work, but sadly all I got was InvalidOperationException:

pQuery = from hit in pQuery 
    where ((DateTime)hit.CreatedAt).Hour >= 6 
       && ((DateTime)hit.CreatedAt).Hour <= 12
    select hit;

Of course I always could filter results after the query using business logic, but that would hinder the performance. Would love a query solution.

Well it is relating to the previous query. You could imagine second pQuery as being just ParseObject.GetQuery("Hits"). — jigglypuff
– jigglypuff, Commented Oct 15, 2014 at 16:43

RotaJota · Accepted Answer · 2014-10-16 21:06:54Z

1

I don't think you can do it the way you're thinking - the createdAt field is just a UNIX timestamp. Instead, you could try adding a new field (or fields) to track the time. Create a beforeSave method for that class that populates those fields anytime a new object gets created. Then you can query against those new fields.

The tricky part here will be dealing with timezones, so take that into consideration.

answered Oct 16, 2014 at 21:06

RotaJota

8419 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Query parse.com by time, not date

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